skills.rest
ariesanhthu
ariesanhthuCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-expert

Analyze EXPLAIN plans and optimize queries for PostgreSQL, MySQL, MongoDB, and SQLite.

Updated Mar 15, 2026
Search Tags:#performance#schema design#database#optimization#sql#connection pooling#query tuning
One-click install
npx skills add https://github.com/ariesanhthu/HiveK --skill database-expert-ariesanhthu
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-expert
Source: https://github.com/ariesanhthu/HiveK/tree/main/.agent/skills/database-expert
Command: npx skills add https://github.com/ariesanhthu/HiveK --skill database-expert-ariesanhthu

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill addresses challenges related to database performance, schema design, query optimization, and connection management across various database systems and ORMs.

Core Features & Use Cases

  • Performance Tuning: Analyzes and optimizes slow queries, indexing strategies, and storage.
  • Schema Design: Assists with designing efficient database schemas and managing migrations.
  • Connection Management: Helps resolve issues with connection pooling, transactions, and deadlocks.
  • Use Case: Improve the response time of a web application by optimizing slow database queries and ensuring efficient connection handling.

Quick Start

Use the database-expert skill to analyze the performance of a slow SQL 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 slow database queries using EXPLAIN plans?▼

To optimize slow database queries, you must analyze EXPLAIN plans to identify execution bottlenecks. This Skill evaluates query paths and indexing strategies to provide targeted solutions for improving database performance across PostgreSQL, MySQL, MongoDB, and SQLite.

What is the best way to design an efficient database schema and manage migrations?▼

Designing an efficient database schema involves structuring constraints and managing migrations accurately. This Skill assists by analyzing schema structures to ensure data integrity and optimize storage across supported relational and NoSQL systems.

How does connection pooling resolve database deadlocks and transaction issues?▼

Connection pooling resolves database deadlocks by managing how application database connections interact with transaction handling. This Skill analyzes connection metrics to resolve pooling issues, deadlocks, and transaction bottlenecks for improved response times.

Can I use this for query tuning and ORM integration with MongoDB or SQLite?▼

Yes, you can use this for query tuning and ORM integration with MongoDB or SQLite. The Skill optimizes query speed, indexing, and schema constraints across PostgreSQL, MySQL, MongoDB, and SQLite while supporting ORM integration.

Why does my web application have slow response times despite efficient indexing?▼

Slow response times despite efficient indexing often stem from poor connection management or unoptimized transaction handling. This Skill analyzes connection metrics, pooling, and EXPLAIN execution plans to identify and solve underlying query speed issues.

Related Skills

Explore More Software Engineering Skills→
cathayriskcathayrisk

supabase-postgres-best-practices

Analyze SQL and EXPLAIN plans to optimize Supabase Postgres queries and schemas.

Community
Advanced
JesusFigueroa25JesusFigueroa25

Database Optimizer

Optimize PostgreSQL and MySQL database performance through schema, query, and indexing analysis.

Community
Advanced
vuralserhat86vuralserhat86
43

drizzle_orm

Facilitate type-safe ORM for Cloudflare D1 databases with Drizzle.

Community
Advanced
interflownexinterflownex
2

cloud-sql-mysql-monitor

Analyze MySQL query metrics and resource utilization on Google Cloud SQL.

Community
Advanced