Analyze database queries and propose index and schema improvements.
npx skills add https://github.com/0xkynz/codekit --skill database-expert-0xkynz
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
Optimize database performance and design efficient schemas across major DBs.
Analyze my PostgreSQL database and propose an index and schema design improvements for a slow query.
High-intent search queries and answers about installing and using this skill.
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.
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.
Yes, this database optimization approach provides cross-database guidance explicitly tailored for both OLTP and analytical contexts across PostgreSQL, MySQL, MongoDB, and SQLite systems.
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.
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.
phuetzManage PostgreSQL, MongoDB, and Redis via unified CLI workflows.
codeApe-7Analyze PostgreSQL and MySQL query performance and recommend index and configuration tuning.
isharoverwhiteImplement SQLAlchemy 2.0 ORM models for Python database operations.
AndyAnh174Optimize relational and cloud database performance through index tuning and query rewriting.
