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.
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-designsql 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-patternscreating 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-plancreating 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-testscreating 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-reportsql 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-queriespostgres 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-prosql 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-prosql 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-testingsql 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-insightazure 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-dotnetazure 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-dotnetazure 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-dotnetmigrate 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-hypertablespostgres
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:
postgrespostgres 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-migrationhistoric 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_patternshistoric 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_digestpostgresql 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-planningsupabase 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-practicesazure 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-sqlgcp 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-sqlmysql
Administer MySQL/MariaDB databases. Configure replication and optimize performance. Use when managing MySQL deployments.
BagelHole/DevOps-Security-Agent-Skills★ 1.2kMITFolder:
mysqlpostgresql 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-cloudbasepostgresql 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-cloudbaseStrix•SQL 注入
Strix SQL 注入测试手册,覆盖 union、blind、error-based 与 ORM 绕过技巧;触发名:strix-sql-injection
asdfgh1445/ctf-super-hub★ 840Licence: see repoFolder:
strix-sql-injectionazure 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-mysqlazure 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-postgresqlGé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-textueloptimizing 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-sqlsql explainer
Explain what a SQL query does in plain language and point out joins that may multiply rows.
zhuyansen/agent-skills-hub★ 478MITFolder:
sql-explainer704 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-sqlsqlite 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-opssql 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-patternspostgresql 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-reviewpostgresql 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-optimizationsql parameterized
Rule matrix negative fixture - uses parameterized SQL queries safely; not intended for production deployment.
bruc3van/agent-skills-guard★ 392MITFolder:
sql-parameterizedsql 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-injectionsql 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-buildersql 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-expertoptimize clickhouse sql
Optimize slow queries, analyze SQL performance, and collect evidence for expensive workloads.
FrankChen021/datastoria★ 327Licence: see repoFolder:
optimize-clickhouse-sqlmysql best practices
MySQL development best practices for schema design, query optimization, and database administration
Mindrally/skills★ 288Apache-2.0Folder:
mysql-best-practicestool.sql queries.1652b99c183e58c4
Write correct, performant SQL across all major data warehouse dialects
AI45Lab/OpenART★ 260AGPL-3.0Folder:
tool.sql_queries.1652b99c183e58c4tool.sql queries.70cb8579d686cf19
"\uBAA8\uB4E0 \uC8FC\uC694 \uB370\uC774\uD130 \uC6E8\uC5B4\uD558\uC6B0\
AI45Lab/OpenART★ 260AGPL-3.0Folder:
tool.sql_queries.70cb8579d686cf19tool.sql queries.50fd9e618e4fbdd3
Write correct, performant, readable SQL across all major data warehouse
AI45Lab/OpenART★ 260AGPL-3.0Folder:
tool.sql_queries.50fd9e618e4fbdd3bun sqlite
Use for bun:sqlite, SQLite operations, prepared statements, transactions, and queries.
secondsky/claude-skills★ 240MITFolder:
bun-sqlitesql 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-generationsql 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-explainmigrating 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-dbtoptimizing 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.