Slow database queries can make your application feel sluggish. This skill helps you find and fix those problems. It gives you expert advice on query tuning, indexing strategies, and performance analysis for any SQL database.
You will see clear examples of bad and good SQL code. Learn how to use execution plans, improve pagination, and speed up batch operations. The tips work with MySQL, PostgreSQL, SQL Server, Oracle, and others.
Whether you manage a small app or a large system, this guide helps your database run faster and smoother. No complicated jargon. Just practical steps to boost performance.
Global
mkdir -p ~/.claude/skills/sql-optimizationProject
mkdir -p .claude/skills/sql-optimizationSource Repository
Supabase Postgres Best Practicessupabase/agent-skills
Follow Supabase's expert guidelines for faster Postgres queries and smarter schema design
Firebase Data Connectfirebase/agent-skills
Build secure PostgreSQL backends with Firebase using GraphQL schemas and type-safe SDKs
Convex Migration Helperget-convex/agent-skills
Plan and run safe Convex schema migrations without downtime or data loss
Firebase Firestorefirebase/agent-skills
Master Cloud Firestore setup, queries, full-text search, security rules, and indexes
Neon Postgresneondatabase/agent-skills
Set up and manage Neon Serverless Postgres with ease and speed
Firebase Firestore Standardfirebase/agent-skills
Set up and secure Cloud Firestore with clear provisioning rules and SDK guides
Firebase Firestore Enterprise Native Modefirebase/agent-skills
Master Firestore Enterprise Native Mode provisioning data modeling security rules and SDK usage
Postgresql Table Designwshobson/agents
Design PostgreSQL tables with best practices for performance and reliability