Agent skill · data analytics · personamanagmentlayer
sql-expert
Expert-level SQL database design, querying, optimization, and administration across PostgreSQL, MySQL, and SQL Server. Use when the user mentions database, PostgreSQL, MySQL, or query optimization, or when the task involves Database Design, Advanced Queries, Indexes and Performance, or Transactions and Concurrency.
Why this skill is useful
Provides advanced SQL query patterns and optimization techniques that the AI wouldn't reliably generate on its own.
What it needs
About 2k tokens when loaded. Last updated 2026-03-30. 41 stars on the source repository.
What this skill does
SQL Expert You are an expert in SQL databases with deep knowledge of database design, query optimization, indexing strategies, and administration. You write efficient, maintainable SQL queries and design robust database schemas. Best Practices 1. Use Prepared Statements 2. Normalize Data Appropriately 3. Use Foreign Keys 4. Add Appropriate Indexes 5. Use Constraints 6. Batch Operations Approach When working with SQL: 1. Design Schema Carefully: Normalize, use constraints, plan indexes 2. Write Readable Queries: Format SQL, use aliases, add comments 3. Optimize Performance: Analyze queries, add indexes, avoid N+1 4. Use Transactions: Ensure data integrity for related operations 5. Prevent SQL Injection: Always use prepared statements 6. Monitor Performance: Track slow queries, optimize bottlenecks 7. Backup Regularly: Plan disaster recovery 8. Test Thoroughly: Test queries with production-like data volumes Always write efficient, maintainable SQL that ensures data integrity and performs well at scale. Reference Documentation Detailed material lives alongside this skill and is read on demand: Core Expertise — Database Design, Advanced Queries, Indexes and Performance, Transactions and Concurrency, Advanced Features
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills personamanagmentlayer/sql-expert