Claude skills for SQL

455 public Claude skills touch on SQL. These 50 are the closest fit, best-known sources first. Each links to its folder; copy it into ~/.claude/skills/ to use it.

  1. postgresql table design

    Use this skill when designing or reviewing a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

    wshobson/agents★ 42kMITFolder: postgresql-table-design

  2. sql optimization patterns

    Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.

    wshobson/agents★ 42kMITFolder: sql-optimization-patterns

  3. creating oracle to postgres master migration plan

    Discovers all projects in a .NET solution, classifies each for Oracle-to-PostgreSQL migration eligibility, and produces a persistent master migration plan. Use when starting a multi-project Oracle-to-PostgreSQL migration, creating a migration inventory, or…

    github/awesome-copilot★ 41kMITFolder: creating-oracle-to-postgres-master-migration-plan

  4. creating oracle to postgres migration integration tests

    Creates integration test cases targeting Oracle for .NET data access artifacts. Tests capture Oracle expected behavior as the authoritative baseline; they are written once and later ported to PostgreSQL by migrating the test project in Phase 6. Use only…

    github/awesome-copilot★ 41kMITFolder: creating-oracle-to-postgres-migration-integration-tests

  5. creating oracle to postgres migration bug report

    Creates structured bug reports for defects found during Oracle-to-PostgreSQL migration. Use when documenting behavioral differences between Oracle and PostgreSQL as actionable bug reports with severity, root cause, and remediation steps.

    github/awesome-copilot★ 41kMITFolder: creating-oracle-to-postgres-migration-bug-report

  6. sql queries

    Generate SQL queries from natural language descriptions. Supports BigQuery, PostgreSQL, MySQL, and other dialects. Reads database schemas from uploaded diagrams or documentation. Use when writing SQL, building data reports, exploring databases, or…

    phuryn/pm-skills★ 28kMITFolder: sql-queries

  7. postgres pro

    Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features. Invoke for EXPLAIN analysis, JSONB operations, extension usage, VACUUM tuning, performance monitoring.

    Jeffallan/claude-skills★ 12kMITFolder: postgres-pro

  8. sql pro

    Optimizes SQL queries, designs database schemas, and troubleshoots performance issues. Use when a user asks why their query is slow, needs help writing complex joins or aggregations, mentions database performance issues, or wants to design or migrate a…

    Jeffallan/claude-skills★ 12kMITFolder: sql-pro

  9. sql injection testing

    This skill should be used when the user asks to "test for SQL injection vulnerabilities", "perform SQLi attacks", "bypass authentication using SQL injection", "extract database information through injection", "detect SQL injection flaws", or "exploit…

    zebbern/claude-code-guide★ 4.7kMITFolder: sql-injection-testing

  10. sql insight

    Translate natural language to SQL, optimize query performance, and interpret EXPLAIN plans for SQLite and PostgreSQL. Triggered when users ask to convert questions into SQL, improve slow queries, tune indexes, analyze execution plans, or mention keywords…

    zebbern/claude-code-guide★ 4.7kMITFolder: sql-insight

  11. azure resource manager mysql dotnet

    Azure MySQL Flexible Server SDK for .NET. Database management for MySQL Flexible Server deployments. Use for creating servers, databases, firewall rules, configurations, backups, and high availability. Triggers: "MySQL", "MySqlFlexibleServer", "MySQL…

    microsoft/skills★ 3.2kMITFolder: azure-resource-manager-mysql-dotnet

  12. azure resource manager postgresql dotnet

    Azure PostgreSQL Flexible Server SDK for .NET. Database management for PostgreSQL Flexible Server deployments. Use for creating servers, databases, firewall rules, configurations, backups, and high availability. Triggers: "PostgreSQL",…

    microsoft/skills★ 3.2kMITFolder: azure-resource-manager-postgresql-dotnet

  13. azure resource manager sql dotnet

    Azure Resource Manager SDK for Azure SQL in .NET. Use for MANAGEMENT PLANE operations: creating/managing SQL servers, databases, elastic pools, firewall rules, and failover groups via Azure Resource Manager. NOT for data plane operations (executing…

    microsoft/skills★ 3.2kMITFolder: azure-resource-manager-sql-dotnet

  14. migrate postgres tables to hypertables

    Use this skill to migrate identified PostgreSQL tables to Timescale/TimescaleDB hypertables with optimal configuration and validation.

    timescale/pg-aiguide★ 1.9kApache-2.0Folder: migrate-postgres-tables-to-hypertables

  15. postgres

    Use this skill for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations.

    timescale/pg-aiguide★ 1.9kApache-2.0Folder: postgres

  16. postgres database migration

    Use this skill for planning, testing, and safely executing PostgreSQL schema migrations — especially when working with production data or shared databases.

    timescale/pg-aiguide★ 1.9kApache-2.0Folder: postgres-database-migration

  17. historic sql patterns

    Identify recurring cross-table historic-SQL analytical intents from a bounded pattern shard and emit typed pattern evidence for deterministic wiki projection.

    Kaelio/ktx★ 1.6kApache-2.0Folder: historic_sql_patterns

  18. historic sql table digest

    Convert one changed historic-SQL table usage bucket into typed table usage evidence for deterministic _schema projection.

    Kaelio/ktx★ 1.6kApache-2.0Folder: historic_sql_table_digest

  19. postgresql planning

    Plan and implement OpenMeld PostgreSQL business persistence, schemas and migrations, transactions, Hyperdrive access, and data cutover. Use for the shared relational database transition or PostgreSQL work; not for unrelated D1 performance fixes or…

    amplifthq/openmeld★ 1.4kMITFolder: postgresql-planning

  20. supabase postgres best practices

    Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that lives in a Postgres database: creating or altering tables and columns (including choosing column types), schema design,…

    fcakyon/claude-codex-settings★ 1.2kApache-2.0Folder: supabase-postgres-best-practices

  21. azure sql

    Provision Azure SQL Database and Cosmos DB. Configure security, backups, and replication. Use when deploying managed databases on Azure.

    BagelHole/DevOps-Security-Agent-Skills★ 1.2kMITFolder: azure-sql

  22. gcp cloud sql

    Provision Cloud SQL and Spanner databases. Configure high availability, backups, and security. Use when deploying managed databases on GCP.

    BagelHole/DevOps-Security-Agent-Skills★ 1.2kMITFolder: gcp-cloud-sql

  23. mysql

    Administer MySQL/MariaDB databases. Configure replication and optimize performance. Use when managing MySQL deployments.

    BagelHole/DevOps-Security-Agent-Skills★ 1.2kMITFolder: mysql

  24. postgresql best practices cloudbase

    CloudBase PostgreSQL access-pattern and slow-query quality guidance. Use when designing how tables are read and written, eliminating per-row database calls, adding indexes for filters or joins, reviewing high-traffic data access, or explaining a slow SQL…

    TencentCloudBase/CloudBase-AI-Toolkit★ 1.2kMITFolder: postgresql-best-practices-cloudbase

  25. postgresql development cloudbase

    Use when building, debugging, or evaluating CloudBase PostgreSQL / CloudBase PG / PG mode apps, including Postgres schema setup, queryPgDatabase/managePgDatabase, JS SDK v3 app.rdb() CRUD/RPC, PG HTTP API fallback, RLS-style permissions, username-password…

    TencentCloudBase/CloudBase-AI-Toolkit★ 1.2kMITFolder: postgresql-development-cloudbase

  26. Strix•SQL 注入

    Strix SQL 注入测试手册,覆盖 union、blind、error-based 与 ORM 绕过技巧;触发名:strix-sql-injection

    asdfgh1445/ctf-super-hub★ 840Licence: see repoFolder: strix-sql-injection

  27. azure database mysql

    Expert knowledge for Azure Database for MySQL development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when…

    MicrosoftDocs/Agent-Skills★ 797CC-BY-4.0Folder: azure-database-mysql

  28. azure database postgresql

    Expert knowledge for Azure Database for PostgreSQL development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when…

    MicrosoftDocs/Agent-Skills★ 797CC-BY-4.0Folder: azure-database-postgresql

  29. Génération SQL DDL depuis description de schéma textuel

    Convertit une description textuelle structurée d'un modèle de données (entités, associations, clés étrangères, règles de fusion) en code SQL CREATE TABLE. Applique les fusions de tables spécifiées et respecte les contraintes d'intégrité référentielle.

    ECNU-ICALK/AutoSkill★ 609No licence statedFolder: génération-sql-ddl-depuis-description-de-schéma-textuel

  30. optimizing sql

    Optimize SQL query performance through EXPLAIN analysis, indexing strategies, and query rewriting for PostgreSQL, MySQL, and SQL Server. Use when debugging slow queries, analyzing execution plans, or improving database performance.

    ancoleman/ai-design-components★ 525MITFolder: optimizing-sql

  31. sql explainer

    Explain what a SQL query does in plain language and point out joins that may multiply rows.

    zhuyansen/agent-skills-hub★ 478MITFolder: sql-explainer

  32. 704 technologies sql

    Use when you need framework-agnostic SQL guidance — schema naming, relational table design, query readability, indexes, transactions, database security, migrations, testing, and monitoring — without choosing Spring Boot, Quarkus, or Micronaut. This should…

    jabrena/plinth★ 456Apache-2.0Folder: 704-technologies-sql

  33. sqlite ops

    Patterns for SQLite databases in Python projects - state management, caching, and async operations. Triggers on: sqlite, sqlite3, aiosqlite, local database, database schema, migration, wal mode.

    aiskillstore/marketplace★ 446No licence statedFolder: sqlite-ops

  34. sql patterns

    Quick reference for common SQL patterns, CTEs, window functions, and indexing strategies. Triggers on: sql patterns, cte example, window functions, sql join, index strategy, pagination sql.

    aiskillstore/marketplace★ 446No licence statedFolder: sql-patterns

  35. postgresql code review

    PostgreSQL-specific code review assistant focusing on PostgreSQL best practices, anti-patterns, and unique quality standards. Covers JSONB operations, array usage, custom types, schema design, function optimization, and PostgreSQL-exclusive security…

    syahiidkamil/Software-Engineer-AI-Agent-Atlas★ 404No licence statedFolder: postgresql-code-review

  36. postgresql optimization

    PostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data types, and PostgreSQL-exclusive capabilities. Covers JSONB operations, array types, custom types, range/geometric types, full-text search, window functions, and…

    syahiidkamil/Software-Engineer-AI-Agent-Atlas★ 404No licence statedFolder: postgresql-optimization

  37. sql parameterized

    Rule matrix negative fixture - uses parameterized SQL queries safely; not intended for production deployment.

    bruc3van/agent-skills-guard★ 392MITFolder: sql-parameterized

  38. sql injection

    Rule matrix security fixture for sql_injection used by security rule matrix integration tests; not intended for production deployment.

    bruc3van/agent-skills-guard★ 392MITFolder: sql-injection

  39. sql query builder

    Build SQL queries for construction databases. Generate optimized SQL queries for construction data retrieval

    datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction★ 375MITFolder: sql-query-builder

  40. sql expert

    Expert system for generating, validating, and optimizing ClickHouse SQL. Use this when the user needs data, queries, or analysis.

    FrankChen021/datastoria★ 327Licence: see repoFolder: sql-expert

  41. optimize clickhouse sql

    Optimize slow queries, analyze SQL performance, and collect evidence for expensive workloads.

    FrankChen021/datastoria★ 327Licence: see repoFolder: optimize-clickhouse-sql

  42. mysql best practices

    MySQL development best practices for schema design, query optimization, and database administration

    Mindrally/skills★ 288Apache-2.0Folder: mysql-best-practices

  43. tool.sql queries.1652b99c183e58c4

    Write correct, performant SQL across all major data warehouse dialects

    AI45Lab/OpenART★ 260AGPL-3.0Folder: tool.sql_queries.1652b99c183e58c4

  44. tool.sql queries.70cb8579d686cf19

    "\uBAA8\uB4E0 \uC8FC\uC694 \uB370\uC774\uD130 \uC6E8\uC5B4\uD558\uC6B0\

    AI45Lab/OpenART★ 260AGPL-3.0Folder: tool.sql_queries.70cb8579d686cf19

  45. tool.sql queries.50fd9e618e4fbdd3

    Write correct, performant, readable SQL across all major data warehouse

    AI45Lab/OpenART★ 260AGPL-3.0Folder: tool.sql_queries.50fd9e618e4fbdd3

  46. bun sqlite

    Use for bun:sqlite, SQLite operations, prepared statements, transactions, and queries.

    secondsky/claude-skills★ 240MITFolder: bun-sqlite

  47. sql query generation

    Generate SQL queries from natural-language requirements using SELECT, JOIN, GROUP BY, window functions, CTEs, and subqueries. Use when the user needs a new query from a business question or schema; use query-optimization when an existing query or execution…

    seb1n/awesome-ai-agent-skills★ 233MITFolder: sql-query-generation

  48. sql explain

    Explains a PostgreSQL EXPLAIN ANALYZE plan and points at the slowest node. Use when the user pastes a query plan; not for rewriting schemas.

    Goldziher/ai-rulez★ 165MITFolder: sql-explain

  49. migrating sql to dbt

    Converts legacy SQL to modular dbt models. Use when migrating SQL to dbt for: (1) Converting stored procedures, views, or raw SQL files to dbt models (2) Task mentions "migrate", "convert", "legacy SQL", "transform to dbt", or "modernize" (3) Breaking…

    AltimateAI/data-engineering-skills★ 130MITFolder: migrating-sql-to-dbt

  50. optimizing databricks sql

    Analyze DBSQL queries, including SQL embedded in notebooks (`spark.sql(...)`, `%sql` cells), for anti-patterns, lint issues, and performance problems, using Databricks-specific dialect and platform knowledge (Delta, Photon, Unity Catalog) layered on top of…

    AltimateAI/data-engineering-skills★ 130MITFolder: optimizing-databricks-sql

Claude skills for SQL: common questions

Is there a Claude skill for SQL?

There are 455 of them, spread over 192 repositories on GitHub. Named for it and most starred: postgresql table design (wshobson/agents, ★ 42k), sql optimization patterns (wshobson/agents, ★ 42k) and creating oracle to postgres master migration plan (github/awesome-copilot, ★ 41k). Stars rate the repository a skill sits in, not the skill.

How do I install a Claude skill for SQL?

For SQL, take the postgresql-table-design folder from wshobson/agents (the folder that holds SKILL.md) into ~/.claude/skills/ to use it in every Claude Code project, or into .claude/skills/ for one project. In the Claude apps, zip that folder and upload it as a custom skill in settings.

Are all these SQL skills in English?

No: Strix•SQL 注入 is written mainly in Chinese, Japanese, Korean or Russian rather than English, though the SQL task is the same. Claude can follow it either way, but read it before you install.

What should I check before installing a SQL skill?

A SQL skill is instructions Claude follows, and it can bundle scripts Claude runs, so read SKILL.md and every script first: for postgresql table design, that is everything in the postgresql-table-design folder. Red flags: piping a download into a shell, sending files to a URL, and instructions to hide what it does from you.

Are these SQL skills maintained?

337 of the 455 SQL skills sit in repositories that changed in the 30 days before 31 Oct 2026.

Are these SQL skills official?

No. None of the 455 SQL skills comes from Anthropic's own skills repository, so all of them are community-made across 192 repositories.

More topics: every “Claude skills for…” page.