skills.rest
hiktan44
hiktan44COMMUNITY
Explore all skills by this author →
GitHub

Database Optimizer

Optimize PostgreSQL, MySQL, Supabase, and PlanetScale database performance.

Updated Aug 27, 2026
Search Tags:#performance#indexing#schema design#database#postgresql#optimization#sql
One-click install
npx skills add https://github.com/hiktan44/deer-flow --skill database-optimizer-hiktan44
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Database Optimizer
Source: https://github.com/hiktan44/deer-flow/tree/main/skills/public/engineering-database-optimizer
Command: npx skills add https://github.com/hiktan44/deer-flow --skill database-optimizer-hiktan44

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses the critical need for efficient and scalable database performance, preventing slow queries and system downtime.

Core Features & Use Cases

  • Schema Design: Creates robust and scalable database schemas.
  • Query Optimization: Analyzes and improves the performance of SQL queries using tools like EXPLAIN ANALYZE.
  • Indexing Strategies: Implements effective indexing for faster data retrieval.
  • Use Case: Optimize a slow-running PostgreSQL query that is causing application latency by analyzing its execution plan and adding appropriate indexes.

Quick Start

Optimize the provided SQL query for PostgreSQL by analyzing its execution plan and suggesting index improvements.

Frequently Asked Questions about Database Optimizer

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

FAQPage Schema
How do I fix slow PostgreSQL queries causing application latency?▼

Fix slow PostgreSQL queries by analyzing the execution plan with EXPLAIN ANALYZE to identify bottlenecks and implementing appropriate indexing strategies for faster data retrieval.

What is the best way to resolve N+1 problems in MySQL and Supabase?▼

Resolve N+1 problems in MySQL and Supabase by optimizing schema design and query structures to batch data retrieval, eliminating repetitive database calls and improving overall system scalability.

Does this database optimization approach work with PlanetScale and Supabase?▼

Yes, this database optimization approach works with PlanetScale and Supabase, alongside PostgreSQL and MySQL, applying schema design, query optimization, and indexing strategies tailored to each platform's architecture.

How do I use EXPLAIN ANALYZE to improve database indexing?▼

Use EXPLAIN ANALYZE to review your SQL execution plans, identify full table scans or inefficient joins, and then apply targeted indexing strategies to accelerate data retrieval for complex queries.

When should I optimize my database schema design for better performance?▼

Optimize your database schema design when experiencing slow queries, system downtime, or N+1 problems, ensuring robust and scalable data structures that prevent inefficient retrieval and support application growth.

Related Skills

Explore More Software Engineering Skills→
Likas07Likas07

database-optimizer

Analyze SQL queries and schema design for PostgreSQL, MySQL, Supabase, and PlanetScale.

Community
Advanced
cathayriskcathayrisk

supabase-postgres-best-practices

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

Community
Advanced
djankiesdjankies

configuring-connection-pools

Configure Prisma Client connection pools for PostgreSQL deployments.

Community
Advanced
dhruvinrsonidhruvinrsoni

caching-strategy

Design and implement caching layers with Redis, Memcached, or in-memory stores.

Community
Advanced