Topic · Databases
Best SQL skills, page 3
SQL skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 97 | A skill your agent uses when user asks to create/edit/query Online reports, SQL reports, data reports, or says "创建报表", "生成报表", "新建报表", "查询报表", "online报表", "SQL报表", "数据报表", "统计报表", "create report"… | jeecgboot/ | 239 | — | ~5.8k | Automated safety check: Pass | Apache-2.0 | 20 days ago |
| 98 | 98.Srtd CLI This skill should be used when the user mentions "srtd", "sql templates", "migrations-templates", "live reload sql", "supabase functions", when working with files in supabase/migrations-templates/… | t1mmen/ | 105 | — | ~360 | Automated safety check: Pass | MIT | 1 mo ago |
| 99 | 99.Archaeology Retrieve proven SQL patterns, table cheatsheets, and join patterns from .knowledge/query-archaeology/ so past work gets reused. | ai-analyst-lab/ | 304 | — | ~1.3k | Automated safety check: Pass | MIT | 7 days ago |
| 100 | Creates or modifies dbt models in line with a project's own conventions, then runs dbt build and dbt show to check the output instead of stopping at compile. | AltimateAI/ | 128 | — | ~890 | Automated safety check: Pass | MIT | 6 days ago |
| 101 | 101.Sap Abap Comprehensive ABAP development skill for SAP systems. An agent skill from secondsky/sap-skills. | secondsky/ | 462 | — | ~3.9k | Automated safety check: Pass | GPL-3.0 | 2 days ago |
| 102 | 102.Faasjs Pg A skill your agent uses when working with @faasjs/pg or PostgreSQL in FaasJS: Tables declaration merging, QueryBuilder, select aliases, parameterized sql expressions, raw SQL, numeric/decimal/bigint… | faasjs/ | 121 | — | ~718 | Automated safety check: Pass | MIT | 1 mo ago |
| 103 | 103.Docs Writer Write or update documentation in docs/sphinx/source/. An agent skill from FoundationDB/fdb-record-layer. | FoundationDB/ | 675 | — | ~925 | Automated safety check: Pass | Apache-2.0 | today |
| 104 | 104.Fetch Data 取数 / 查数据 / 拉数据 / 跑 SQL。把自然语言取数需求转为 SQL,经数据湖仓执行后返回查询结果供下游分析。任何需要业务数据的任务在工作区缺少对应文件时都必须先调用此技能——覆盖 BI 业务分析、留存 / 转化 / 同期群分析、数据探索 EDA、统计建模、定量计算、元数据查询、数据查询。命中任一即触发:(1) 直接索要指标或记录,如「DAU 多少」「上月销售额」「3… | agentscope-ai/ | 113 | — | ~2.5k | Automated safety check: Pass | Apache-2.0 | 3 days ago |
| 105 | 105.Ravendb Read this before writing any RavenDB query, client call or /databases/ request. | ravendb/ | 115 | — | ~2.3k | Automated safety check: Pass | MIT | yesterday |
| 106 | 106.Release Create a WebCalendar release — bump version, update CHANGELOG.md, verify DB upgrade SQL, generate GitHub release notes, commit/merge/tag/push to trigger CI, then publish curated release notes. | craigk5n/ | 173 | — | ~5.2k | Automated safety check: Warn | GPL-2.0 | 2 days ago |
| 107 | 107.Mz Query Perf Analyze and optimize a Console/catalog SQL query in user space — diagnose its plan on real relations, then measure candidate rewrites with a faithful synthetic-fleet sweep. | MaterializeInc/ | 6.4k | — | ~2.1k | Automated safety check: Pass | Unknown | today |
| 108 | Develop Forge business approval workflows backed by Flowable, using the current sample purchase order approval as the reference. | yaomindong1996/ | 125 | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | today |
| 109 | 109.DB Context Complete knowledge of the optimizer PostgreSQL database: 57 ingestion tables, schema, relationships, live row counts, query patterns, and conventions. | SilvioBaratto/ | 176 | — | ~6.4k | Automated safety check: Notes | Unknown | today |
| 110 | Skill for Graph Query Language (GQL) or SQL/PGQ queries against a property graph. | google/ | 22k | — | ~4.8k | Automated safety check: Pass | Apache-2.0 | today |
| 111 | 111.Database Use BEFORE editing any file in supabase/migrations/ or supabase/schemas/, OR when the user runs a /database subcommand (compact local migration, rls scenarios, align). | gridaco/ | 2.7k | — | ~3.2k | Automated safety check: Pass | Apache-2.0 | today |
| 112 | Load this FIRST whenever working with PyTorch CI data (any pytorch/ org repo), the torchci/HUD codebase, or the PyTorch HUD ClickHouse database. | pytorch/ | 113 | — | ~2.8k | Automated safety check: Pass | Unknown | today |
| 113 | 113.Databricks CLI Expert guidance for using the Databricks CLI to manage Databricks workspaces, clusters, jobs, pipelines, Unity Catalog, SQL warehouses, serving endpoints, secrets, bundles, and all other Databricks… | aehrc/ | 137 | — | ~2.1k | Automated safety check: Pass | Apache-2.0 | today |
| 114 | CodeIgniter 框架特效安全审计工具。针对 CodeIgniter 的 CSRF、XSS 输出过滤、数据库查询构造、路由与验证器配置、会话 Cookie 安全等机制进行白盒静态审计,并映射到通用漏洞类型体系(CSRF/AUTH/XSS/SQL/CFG/SESS 等)。 | 0xShe/ | 402 | 1 repo | ~477 | Automated safety check: Pass | No licence | 6 mo ago |
| 115 | 115.SQL Help write, debug, and explore SQLite database queries using Kysely. | sendou-ink/ | 297 | — | ~423 | Automated safety check: Pass | AGPL-3.0 | today |
| 116 | Walks through fixing dbt compilation, database and test errors: read the full error, check upstream models, apply a fix, then verify with dbt build and a data preview. | AltimateAI/ | 128 | — | ~1.1k | Automated safety check: Pass | MIT | 6 days ago |
| 117 | Execute runnable docs snippets and examples inside a disposable Docker Compose sandbox (runner container + local Supabase stack via supabase start). | supabase/ | 111k | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | today |
| 118 | Activate this skill for querying DataJunction (DJ) — finding nodes, generating SQL, fetching metric data, exploring lineage, visualizing results — via the DJ UI, MCP tools, or REST/GraphQL APIs. | DataJunction/ | 161 | — | ~2k | Automated safety check: Pass | MIT | today |
| 119 | 119.SQL Expert Expert system for generating, validating, and optimizing ClickHouse SQL. | FrankChen021/ | 327 | — | ~919 | Automated safety check: Pass | Unknown | 2 mo ago |
| 120 | 120.Drizzle Orm Type-safe SQL ORM for TypeScript with zero runtime overhead. An agent skill from growupanand/ConvoForm. | growupanand/ | 101 | 1 repo | ~2.7k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 121 | 121.Expert Database 数据库优化专家入口。用于 Codex CLI 的 $expert-database 调用. An agent skill from ReJeCtAll/ExpertTeam-Codex. | ReJeCtAll/ | 113 | — | ~692 | Automated safety check: Pass | MIT | 3 mo ago |
| 122 | 122.Mz Query Tracing Debug SQL execution time via distributed tracing (OpenTelemetry / Tempo). | MaterializeInc/ | 6.4k | — | ~1.8k | Automated safety check: Pass | Unknown | today |
| 123 | Generate or review Forge project code-generation output for CRUD modules. | yaomindong1996/ | 125 | — | ~1.3k | Automated safety check: Pass | Apache-2.0 | today |
| 124 | Post-generation safety checks for sqlc-gen-moonbit + Cloudflare D1. | mizchi/ | 356 | — | ~995 | Automated safety check: Pass | No licence | 6 days ago |
| 125 | 125.Graincrawl Granola archive: search, sync freshness, notes, transcripts, panels, SQL counts, and Graincrawl repo work. | openclaw/ | 392k | — | ~334 | Automated safety check: Pass | MIT | today |
| 126 | 126.Notcrawl Notion archive: search, sync freshness, pages/databases, Markdown exports, SQL counts, and Notcrawl repo work. | openclaw/ | 392k | — | ~279 | Automated safety check: Pass | MIT | today |
| 127 | 127.Slacrawl Slack archive: search, sync freshness, threads/DMs, SQL counts, and Slacrawl repo work. | openclaw/ | 392k | — | ~315 | Automated safety check: Pass | MIT | today |
| 128 | 128.Postgres A skill your agent uses for any PostgreSQL database work — table design, indexing, data types, constraints, extensions (pgvector, PostGIS, TimescaleDB), search, and migrations. | timescale/ | 1.9k | — | ~941 | Automated safety check: Pass | Apache-2.0 | today |
| 129 | 129.Database Guide MySQL database development guide for the HMIS project. An agent skill from hmislk/hmis. | hmislk/ | 236 | — | ~664 | Automated safety check: Pass | GPL-3.0 | today |
| 130 | Query and analyze NKI kernel profile data from neuron-explorer parquet files. | uw-syfi/ | 103 | — | ~4.3k | Automated safety check: Pass | MIT | today |
| 131 | Run SQL queries against the attached DuckDB database or ad-hoc against files. | duckdb/ | 600 | 1 repo | ~2k | Automated safety check: Notes | MIT | 5 mo ago |
| 132 | Analytics engineering across data modeling, dbt, transformation, and semantic layers. | borghei/ | 881 | — | ~3.4k | Automated safety check: Pass | MIT | today |
| 133 | Build one company memory from a SQL database, a support ticket export and a folder of documents, linked into one graph by cognee, then answer questions that need several of those sources together. | topoteretes/ | 32k | — | ~750 | Automated safety check: Notes | Apache-2.0 | today |
| 134 | 134.Obdiag Triage 未知/未分类问题的统一分诊 SOP:用户描述集群异常但症状不明确、不知从何入手,或问题无法直接对应 rca/observer-log-analysis/observer-sql-analysis 等专项 skill 时,强制先执行全量巡检 checkcluster,再根据巡检结果决定下一步路径。 | oceanbase/ | 163 | — | ~662 | Automated safety check: Pass | MulanPSL-2.0 | 4 mo ago |
| 135 | 135.Python Review Python 遗留代码审查:bare except、SQL 注入、反序列化、密钥、调试输出. An agent skill from liuyanghejerry/Clausura. | liuyanghejerry/ | 204 | — | ~164 | Automated safety check: Pass | MIT | 8 days ago |
| 136 | Activate this skill for DataJunction (DJ) semantic modeling decisions — choosing the right node shape (fact, dimension, transform, metric, cube), turning a draft SQL query into well-designed nodes… | DataJunction/ | 161 | — | ~4.3k | Automated safety check: Pass | MIT | today |
| 137 | Standards for writing tests in fdb-record-layer. An agent skill from FoundationDB/fdb-record-layer. | FoundationDB/ | 675 | — | ~792 | Automated safety check: Pass | Apache-2.0 | today |
| 138 | Queries MySQL or MariaDB databases declared in .env by label, read-only by default unless a connection explicitly allows writes. | evolution-foundation/ | 545 | — | ~1.9k | Automated safety check: Notes | Unknown | 4 mo ago |
| 139 | CloudBase PostgreSQL access-pattern and slow-query quality guidance. | TencentCloudBase/ | 1.1k | 1 repo | ~1.3k | Automated safety check: Pass | MIT | yesterday |
| 140 | Flags and fixes performance issues in WooCommerce PHP code: missing post cache priming, uncached option lookups in loops, and inefficient SQL query patterns. | woocommerce/ | 11k | — | ~395 | Automated safety check: Pass | Unknown | today |
| 141 | Queries the TOTVS Protheus ERP data dictionary for tables, fields, indexes, parameters, triggers and lookups, including impact checks during refactoring. | totvs/ | 143 | — | ~1.5k | Automated safety check: Pass | MIT | 2 days ago |
| 142 | Change Laravel, TypeORM, or Django migration generation and generated SQL parsing. | AHS12/ | 626 | — | ~425 | Automated safety check: Pass | GPL-3.0 | 1 mo ago |
| 143 | 143.SQL Pro Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. | davila7/ | 32k | 9 repos | ~1.9k | Automated safety check: Pass | MIT | today |
| 144 | 144.TS Review TypeScript monorepo 审查:XSS、SQL 注入、密钥、any、console.log. An agent skill from liuyanghejerry/Clausura. | liuyanghejerry/ | 204 | — | ~166 | Automated safety check: Pass | MIT | 8 days ago |