Topic · Databases
Best SQL skills for Claude Code, Codex and other agents.
- skills
- 558
- official
- 68
SQL skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 1 | Gives the agent Postgres rules to consult before writing or changing tables, queries, indexes, RLS policies or migrations, and when diagnosing slow queries. | supabase/ | 2.7k | 24 repos | ~808 | Automated safety check: Pass | MIT | 5 days ago |
| 2 | Analyzes uploaded Excel and CSV files with SQL through DuckDB, producing schema inspections, statistical summaries and exports to CSV, JSON or Markdown. | bytedance/ | 83k | 4 repos | ~2.2k | Automated safety check: Pass | MIT | today |
| 3 | 3.Geoflow Operate/develop GEOFlow CLI/Laravel/admin/API, topics/专题 and topic tasks, theme libraries/replication, sites/leads/Agent, channel sync and legacy yao-geoflow-cli/design/template migration. | yaojingang/ | 3.8k | — | ~722 | Automated safety check: Pass | AGPL-3.0 | 6 days ago |
| 4 | Guides building or updating a Tabularis database driver plugin in Rust that speaks JSON-RPC over stdio and follows the repository's rules. | TabularisDB/ | 5.1k | — | ~2.1k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 5 | A skill your agent uses when adding a DB migration or a new column/field to a Becca entity in Trilium ("add a migration", "new column on notes/attributes", "ALTER TABLE", "add a field to… | TriliumNext/ | 38k | — | ~2.1k | Automated safety check: Pass | AGPL-3.0 | today |
| 6 | 6.Revops When the user wants help with revenue operations, lead lifecycle management, or marketing-to-sales handoff processes. | AvdLee/ | 802 | 5 repos | ~3.7k | Automated safety check: Pass | Unknown | yesterday |
| 7 | Guides classifying, gap-analyzing and scaffolding support for a new SQL database in pREST, from Postgres-compatible variants to entirely new dialects. | prest/ | 4.6k | — | ~1.6k | Automated safety check: Pass | MIT | yesterday |
| 8 | Code-Nest 多模块全栈项目协作规范与落点导航。Use when modifying this repository for feature development, bug fixing, refactor, API change, SQL migration, or frontend-backend联调 so changes land in the correct module… | xiaou61/ | 770 | — | ~1.3k | Automated safety check: Pass | MIT | 27 days ago |
| 9 | Proposes verified fixes for failing SQL examples in StarRocks docs across three languages and several versions, then opens draft pull requests and never merges. | StarRocks/ | 12k | — | ~7.6k | Automated safety check: Notes | Apache-2.0 | today |
| 10 | A skill your agent uses to analyze an existing PostgreSQL database and identify which tables should be converted to Timescale/TimescaleDB hypertables. | timescale/ | 1.9k | 1 repo | ~2.6k | Automated safety check: Pass | Apache-2.0 | 6 days ago |
| 11 | 11.Chdb SQL A skill your agent uses when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse… | vemetric/ | 394 | 1 repo | ~1.2k | Automated safety check: Pass | Apache-2.0 | today |
| 12 | 12.Wtf Pre-launch and pre-commit audit for vibe coding projects. An agent skill from noobnooc/agent. | noobnooc/ | 1.4k | — | ~2.1k | Automated safety check: Notes | No licence | 1 mo ago |
| 13 | Explore an existing PostgreSQL database before answering questions about its data or writing SQL. | timescale/ | 1.9k | — | ~1.1k | Automated safety check: Pass | Apache-2.0 | 6 days ago |
| 14 | 14.Mz Benchmark Add/modify/debug Materialize perf benchmark scenarios. An agent skill from MaterializeInc/materialize. | MaterializeInc/ | 6.4k | — | ~2.8k | Automated safety check: Pass | Unknown | today |
| 15 | 钉钉 AI 表格(多维表)业务操作。Use when 用户需要操作 AI 表格/多维表/Base/Table、应用模式/App 页面/Widget、建表、查写记录、字段、记录评论、评论回复、访问密钥(API Key)、SQL/PostgreSQL/SELECT/JOIN、筛选、排序、公式、模板、批量导入 CSV 或 JSON、导出、仪表盘、图表、上传附件、数据源配置与同步、按任务 ID… | DingTalk-Real-AI/ | 3.2k | — | ~5.4k | Automated safety check: Pass | Apache-2.0 | 2 days ago |
| 16 | Guides SQLite schema changes in the Cursor BYOK server, keeping SQLx migrations, the Rust store, API contracts and fixtures aligned. | leookun/ | 3.2k | — | ~1.3k | Automated safety check: Pass | MIT | 9 days ago |
| 17 | This skill should be used when user asks to "query OpenObserve", "create OpenObserve dashboard", "edit OpenObserve panel", "fetch OpenObserve logs", "run OpenObserve search", "list OpenObserve… | fcakyon/ | 1.2k | 1 repo | ~4.1k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 18 | 18.Sql2er A skill your agent uses when the user wants a Chen-model ER diagram from SQL CREATE TABLE statements or DBML, wants to rearrange or clean up an existing sql2er state, wants a skeleton-only overview… | ystemsrx/ | 188 | — | ~1.1k | Automated safety check: Pass | AGPL-3.0 | 6 days ago |
| 19 | 19.Kolo Kolo is a text-based Python debugger that captures every executed function, return value, local variable, HTTP request, and SQL query into greppable trace files. | koloai/ | 525 | — | ~1.2k | Automated safety check: Pass | No licence | 5 mo ago |
| 20 | Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. | ynulihao/ | 617 | 10 repos | ~3.3k | Automated safety check: Pass | No licence | 7 mo ago |
| 21 | Debugs logical errors and data discrepancies in Dataflow templates by launching jobs via Terraform and comparing source (e.g. | GoogleCloudPlatform/ | 1.3k | — | ~1.8k | Automated safety check: Pass | Apache-2.0 | today |
| 22 | Web+AI 安全测试知识库。融合 WooYun 88,636 案例 + 先知 L1-L4 方法论 + GAARM 173 风险 + OWASP Top 10 (LLM/ASI/WSTG)。 | Pa55w0rd/ | 423 | — | ~2.7k | Automated safety check: Pass | No licence | 3 mo ago |
| 23 | PostgreSQL database documentation - SQL queries, database design, administration, performance tuning, and advanced features. Use when working with… | 2025Emma/ | 23k | 1 repo | ~19k | Automated safety check: Pass | MIT | 9 mo ago |
| 24 | Analyse whether a SQL query is portable across database implementations using sqlglot transpilation. | HL7/ | 150 | — | ~512 | Automated safety check: Pass | Unknown | yesterday |
| 25 | Deploy this repository to a new Google Cloud project using the repo's existing Cloud Run, Cloud Run Jobs, Cloud SQL, Secret Manager, and Artifact Registry scripts. | besimple-oss/ | 286 | — | ~4.1k | Automated safety check: Pass | MIT | 5 mo ago |
| 26 | 26.Anyline AnyLine数据库操作开发规范,涵盖动态数据源注册切换注销、DDL动态建表改表、DML增删改与事务管理、DQL动态查询与聚合统计、元数据管理、查询结果集的聚合、过滤、格式转换等数学计算,AnyLine方法内部会自动适配100+数据库方言,调用方法时忽略不同数据库差异。 | anylineorg/ | 346 | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | 2 days ago |
| 27 | 27.Squix Run SQL queries across databases (Postgres, MySQL, SQLite, etc.) via the squix CLI. | eduardofuncao/ | 273 | — | ~784 | Automated safety check: Pass | MIT | 15 days ago |
| 28 | 28.Arch Wiki Scans any project codebase for new/changed modules, endpoints, middleware, infrastructure, Docker topologies, SQL queries, or permissions and updates docs/architecture/architecture.json. | ahmedemad3/ | 249 | — | ~5.1k | Automated safety check: Pass | No licence | 18 days ago |
| 29 | 29.Coding Agent Authoring playbook for building agents that write, edit, review, or refactor code. | mastra-ai/ | 29k | — | ~2.3k | Automated safety check: Pass | Unknown | today |
| 30 | 通过 Evotown Database MCP Proxy 对已注册的业务数据库执行只读 SQL 查询。当用户需要查 CRM、订单、报表等结构化数据时使用;禁止直连数据库或写入 SQL。 | EXboys/ | 646 | — | ~425 | Automated safety check: Pass | MIT | 23 days ago |
| 31 | Inspect what a Laravel request actually did — queries, exceptions, timing, cache, auth, views — by reading the profiling data Laravel Debugbar already captured, via Artisan commands. | hexlet-volunteers/ | 114 | 1 repo | ~1.5k | Automated safety check: Pass | AGPL-3.0 | 2 days ago |
| 32 | Generate Perses dashboards or single panels for GreptimeDB. An agent skill from GreptimeTeam/dashboard. | GreptimeTeam/ | 111 | — | ~3.9k | Automated safety check: Pass | Apache-2.0 | 7 days ago |
| 33 | Plans the stack, database schema and API for an app clone, from the recon map replica-recon wrote. | Jakeschincariol/ | 734 | — | ~1.1k | Automated safety check: Pass | MIT | 4 days ago |
| 34 | 34.Sl ktx's semantic layer - a structured catalog of sources (tables/views), measures, joins, and segments expressed as YAML. | Kaelio/ | 1.6k | — | ~2.7k | Automated safety check: Pass | Apache-2.0 | 26 days ago |
| 35 | Specialized skill for working in the fdb-relational-core SQL processing layer — parser, plan generator, and Cascades planner. | FoundationDB/ | 675 | — | ~1k | Automated safety check: Pass | Apache-2.0 | today |
| 36 | Inspects, queries and carefully modifies the MoviePilot SQLite or PostgreSQL database through a bundled script that reads connection settings itself, without needing the password in the prompt. | jxxghp/ | 12k | — | ~7.1k | Automated safety check: Pass | GPL-3.0 | today |
| 37 | Query AutoRAG-Research pipeline results using natural language. | NomaDamas/ | 149 | — | ~1.6k | Automated safety check: Notes | Apache-2.0 | 1 mo ago |
| 38 | Validates SQL schema files for compliance with internal safety and naming policies. | rominirani/ | 591 | — | ~264 | Automated safety check: Pass | No licence | 3 mo ago |
| 39 | Queries the data warehouse with SQL and answers business questions about data. | astronomer/ | 450 | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 40 | A skill your agent uses when a researcher needs to query biomedical databases for biomarker discovery, build target profiles from UniProt/Open Targets/STRING, rank biomarker candidates by evidence… | aws-samples/ | 274 | — | ~1.1k | Automated safety check: Pass | MIT-0 | 5 days ago |
| 41 | 41.Surf Use this skill — NOT browser or webfetch — for ALL Surf crypto-data calls. | BlockRunAI/ | 6.6k | — | ~4k | Automated safety check: Pass | MIT | 2 days ago |
| 42 | Add a field to a domain type so it survives save/load. An agent skill from openfootmanager/openfootmanager. | openfootmanager/ | 1.1k | — | ~1.7k | Automated safety check: Pass | GPL-3.0 | today |
| 43 | 43.Pg Data Generate safe, read-only PostgreSQL queries from natural language. | tyrchen/ | 236 | — | ~2.8k | Automated safety check: Pass | No licence | 6 mo ago |
| 44 | 44.Diesel Guard Lints Diesel and SQLx Postgres migrations for unsafe schema changes that lock tables or cause downtime, and authors custom Rhai checks. | ayarotsky/ | 121 | — | ~3.1k | Automated safety check: Pass | MIT | 9 days ago |
| 45 | 45.Perfetto SQL Translates natural language data intents into syntactically valid Perfetto SQL queries and executes them against a local trace file. | jameshnsears/ | 100 | 2 repos | ~2.7k | Automated safety check: Pass | Apache-2.0 | 1 mo ago |
| 46 | Enforces unit test requirements for the Rust data-processing modules in src-tauri/src/sql/ (generator.rs, parse.rs) and src-tauri/src/reader/ (excel.rs and other readers). | shencangsheng/ | 590 | — | ~1.2k | Automated safety check: Pass | MIT | 1 mo ago |
| 47 | 47.Rhctl Run and author rhctl CLI workflows and remote environment scripts under scripts/ (PostgreSQL, JetStream, Docker, Redis, MongoDB, AWS LocalStack, execute/upload/patch). | saidake/ | 106 | — | ~4k | Automated safety check: Notes | Apache-2.0 | yesterday |
| 48 | Create DAC dashboards by writing YAML or TSX dashboard definition files. | bruin-data/ | 1.8k | — | ~4.3k | Automated safety check: Pass | Apache-2.0 | today |
Questions, answered from the data.
What is the best SQL skill?
Supabase Postgres Best Practices (official) from supabase/agent-skills ranks first of the 558 SQL skills listed here, with the highest score: its repository has 2.7k GitHub stars, 24 other GitHub owners carry a copy, its SKILL.md loads about 808 tokens and it passes the automated safety check with no findings. Next come Excel and CSV Data Analysis and Geoflow.
Which SQL skills are official?
68 of the 558 SQL skills are official, published by the vendor's own GitHub organization: Supabase Postgres Best Practices, Biomarker Database Analysis, Basin, Databricks Dbsql, Logfire Query and 63 more.
How are these skills ranked?
By Skill Navigator score, which combines the GitHub stars of the skill's repository (shared across that repo's skills and discounted for large collections), how many other GitHub owners carry a copy of the skill, and automated SKILL.md quality checks, minus penalties for safety-check warnings and for each further skill from the same repository. Skills that fail the safety check are not listed.