database-expert

Analyze database queries and propose index and schema improvements.

Updated Dec 22, 2025

Search Tags:#performance #database #postgresql #optimization #mongodb #query-tuning #schema-design

Ready to run

npx skills add https://github.com/0xkynz/codekit --skill database-expert-0xkynz

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-expert
Source: https://github.com/0xkynz/codekit/tree/main/templates/skills/database-expert
Command: npx skills add https://github.com/0xkynz/codekit --skill database-expert-0xkynz

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Optimize database performance and design efficient schemas across major DBs.

Core Features & Use Cases

Performance optimization: analyze queries, explain plans, and index tuning strategies.
Schema design: normalization, denormalization, and data modeling for scalable schemas.
Cross-database guidance: applicable to PostgreSQL, MySQL, MongoDB, and SQLite in both OLTP and analytical contexts.
Use Case: when a slow query or poorly designed schema affects an application, this skill provides targeted recommendations and validation steps.

Quick Start

Analyze my PostgreSQL database and propose an index and schema design improvements for a slow query.

Frequently Asked Questions about database-expert

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I optimize a slow PostgreSQL query?▼

To optimize a slow PostgreSQL query, you analyze query execution plans, apply index tuning strategies, and adjust schema design to improve lookup speed and overall database performance.

What is the best way to design a MongoDB schema for scalability?▼

Designing a scalable MongoDB schema involves strategically applying normalization or denormalization techniques to structure your data model for optimal read and write performance at scale.

Can I use this approach for both OLTP and analytical database contexts?▼

Yes, this database optimization approach provides cross-database guidance explicitly tailored for both OLTP and analytical contexts across PostgreSQL, MySQL, MongoDB, and SQLite systems.

How do I identify which database type needs optimization from my project files?▼

You identify the database type needing optimization by analyzing project files to detect PostgreSQL, MySQL, MongoDB, or SQLite configurations, which then directs the specific query tuning recommendations.

Why does my database schema design affect query performance?▼

Your database schema design affects query performance because poorly structured data models force inefficient queries, requiring index tuning and denormalization to reduce latency and restore speed.