Language
SQL agent skills, page 17
SQL skills, ranked
Ranked by score. Sort bymost stars,trending,newest,recently updated
| # | Skill | Repository | Stars | Used in | Tokens | Auto-check | Licence | Updated |
|---|---|---|---|---|---|---|---|---|
| 769 | A skill your agent uses when migrating a dbt project from one data platform or data warehouse to another (e.g., Snowflake to Databricks, Databricks to Snowflake) using dbt Fusion's real-time… | Kilo-Org/ | 189 | — | ~3.9k | Automated safety check: Pass | Apache-2.0 | 9 days ago |
| 770 | Builds and modifies dbt models, writes SQL transformations using ref() and source(), creates tests, and validates results with dbt show. | Kilo-Org/ | 189 | — | ~1.6k | Automated safety check: Pass | Apache-2.0 | 9 days ago |
| 771 | 771.Dune Execute and query Dune Analytics dashboards for on-chain data and custom SQL analytics. | TermiX-official/ | 100 | — | ~1.3k | Automated safety check: Pass | MIT | 4 mo ago |
| 772 | Design the data quality checks for a table or pipeline across the standard dimensions. | mohitagw15856/ | 1.4k | — | ~919 | Automated safety check: Pass | MIT | yesterday |
| 773 | Write a safe, zero-downtime database migration plan for a schema change. | mohitagw15856/ | 1.4k | — | ~4.4k | Automated safety check: Pass | MIT | yesterday |
| 774 | 774.Dbt Model Spec Spec a dbt model — its grain, sources, transformations, tests, and materialization. | mohitagw15856/ | 1.4k | — | ~939 | Automated safety check: Pass | MIT | yesterday |
| 775 | 775.SQL Optimizer Diagnose a slow SQL query and produce a concrete optimization plan. | mohitagw15856/ | 1.4k | — | ~908 | Automated safety check: Pass | MIT | yesterday |
| 776 | Explains, optimises, writes, and documents SQL queries. An agent skill from mohitagw15856/pm-claude-skills. | mohitagw15856/ | 1.4k | — | ~1.6k | Automated safety check: Pass | MIT | yesterday |
| 777 | 777.Code Explanation A skill your agent uses when the user asks to explain what a piece of ADVPL/TLPP code does in plain language, adapting the explanation depth for a junior developer (line-by-line), a senior developer… | thalysjuvenal/ | 185 | — | ~488 | Automated safety check: Pass | MIT | 23 days ago |
| 778 | 778.Embedded SQL A skill your agent uses when the user needs to write, review, or migrate SQL queries in ADVPL/TLPP using BeginSQL/EndSQL blocks and macro expressions (%table%, %xfilial%, %notDel%, %exp%, %Order%)… | thalysjuvenal/ | 185 | — | ~509 | Automated safety check: Pass | MIT | 23 days ago |
| 779 | Optimize Doctrine fetching with DTO hydration (SELECT NEW), fetch joins, lazy loading, query hints, and DBAL 4 access | dev-toolings/ | 222 | — | ~560 | Automated safety check: Notes | MIT | 2 days ago |
| 780 | MindsDB MCP服务器交互技能,用于通过自然语言查询和操作200+企业级数据源。当用户需要查询数据库、分析数据、创建AI模型、连接数据源(MySQL、PostgreSQL、MongoDB、Excel、CSV、Gmail、Slack等)、执行SQL查询、进行数据预测、构建知识库(RAG)、智能问答、文档检索或任何与数据库交互的任务时使用此技能。即使没有明确提到MindsDB,只要涉及数据库操… | LeoYeAI/ | 2.2k | — | ~2.5k | Automated safety check: Pass | MIT | 2 mo ago |
| 781 | 781.Cot Injection 思维链 (Chain-of-Thought) 注入攻击方法论。当目标系统使用 ReAct/CoT 框架进行多步推理、 Agent 依赖中间推理结果做决策、或需要测试思维链完整性时触发。 | wgpsec/ | 1.8k | — | ~640 | Automated safety check: Pass | No licence | 4 days ago |
| 782 | CTF/靶场 Flag 强制验证流程。当通过任何方式发现疑似 flag 字符串(含 flag{、FLAG{、ctf{ 等格式)时必须立即使用此 skill 验证,不要直接提交。防止因字符截断、编码错误、HTML 实体、base64 不完整解码、hex 截断等原因导致提交错误 flag。即使 flag 看起来完整,也可能存在隐藏字符或编码问题。覆盖 SQL… | wgpsec/ | 1.8k | — | ~644 | Automated safety check: Pass | No licence | 4 days ago |
| 783 | Use this Dask sub-skill for Dask DataFrame creation, CSV/Parquet/JSON/SQL IO, partitions and divisions, groupby/aggregation, joins/merge, shuffle, repartitioning, categorical/string/pyarrow… | VectorSpaceLab/ | 328 | — | ~1k | Automated safety check: Pass | BSD-3-Clause | 1 mo ago |
| 784 | 784.Effect TS Effect-TS library usage in TypeScript — Effect.gen generators, Schema.Struct/Schema.Class definitions, Layer/Context.Tag/Service patterns, Effect.pipe pipelines, Data.TaggedError/Data.Class error… | pproenca/ | 214 | — | ~2k | Automated safety check: Pass | MIT | 1 mo ago |
| 785 | 785.Dataproduct Dbt Build out the transformation layers (staging/, intermediate/) of a data product and run dbt against them, following project-wide conventions adapted from dbt's best practices (v1.12). | hashgraph-online/ | 1.2k | — | ~4.3k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 786 | Given an Entropy Data data product URL or id, fetch its data contracts (output port ODCS files written next to the SQL under models/outputports/v<N/, input port ODCS files cached next to their dbt… | hashgraph-online/ | 1.2k | — | ~4.9k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 787 | 787.Filtering A skill your agent uses when the user needs to filter data — whether in a structured query, a metric aggregation, or an attribute expression. | hashgraph-online/ | 1.2k | — | ~1.5k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 788 | A skill your agent uses when exploring Honeydew semantic layer, discovering entities/fields, setting up workspace and branch context, or querying data. | hashgraph-online/ | 1.2k | — | ~2.2k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 789 | 789.Query A skill your agent uses when the user wants to query, analyze, or explore data through the Honeydew semantic layer. | hashgraph-online/ | 1.2k | — | ~3.1k | Automated safety check: Pass | Apache-2.0 | yesterday |
| 790 | Extract database schemas, data models, and entity relationships from code. | EmeaAppGbb/ | 100 | — | ~2.5k | Automated safety check: Pass | MIT | 5 mo ago |
| 791 | 791.Databases Work with MongoDB (document database, BSON documents, aggregation pipelines, Atlas cloud) and PostgreSQL (relational database, SQL queries, psql CLI, pgAdmin). | Microck/ | 401 | — | ~1.9k | Automated safety check: Notes | MIT | 1 mo ago |
| 792 | 792.SQL Run SQL queries against the WordPress development database. An agent skill from Microck/ordinary-claude-skills. | Microck/ | 401 | — | ~573 | Automated safety check: Pass | Unknown | 1 mo ago |
| 793 | 793.SQL Research Guide for researching SQL syntax and behavior for database backends. | Microck/ | 401 | — | ~1.4k | Automated safety check: Pass | Unknown | 1 mo ago |
| 794 | 794.SQL Translation Guide for adding SQL function translations to dbplyr backends. | Microck/ | 401 | — | ~1.3k | Automated safety check: Pass | Unknown | 1 mo ago |
| 795 | MCP playbook for finding and querying SiYuan content. An agent skill from yangtaihong59/siyuan-plugins-mcp-sisyphus. | yangtaihong59/ | 114 | — | ~424 | Automated safety check: Pass | MIT | 6 days ago |
| 796 | 数据库学习与选型技能。面向零基础学习者,系统学习数据结构、事务、索引、查询优化等核心概念,对比 MySQL 与 PostgreSQL 的差异与适用场景。触发词:"数据库学习"、"学数据库"、"数据库入门"、"MySQL vs PostgreSQL"、"数据库索引"、"数据库事务"、"数据库选型"、"数据库查询优化"。 | jiushiwon/ | 110 | — | ~1k | Automated safety check: Pass | Apache-2.0 | 3 days ago |
| 797 | MySQL 学习与选型指南。面向需要了解 MySQL 的开发者,提供核心概念、安装部署、表结构设计、索引优化、事务原理、主从复制、与业务场景匹配推荐等(不含具体框架集成)。触发词:"MySQL 学习"、"MySQL 入门"、"MySQL 选型"、"MySQL 索引"、"MySQL 事务"、"MySQL 设计"、"SQL 优化"。 | jiushiwon/ | 110 | — | ~1.2k | Automated safety check: Pass | Apache-2.0 | 3 days ago |
| 798 | 基于 OWASP Top 10 (2021) 标准提供代码安全审查,逐项检查 SQL 注入、XSS、SSRF、访问控制、加密失败等常见漏洞,并给出具体的漏洞代码示例与修复方案。当用户需要代码安全审查、安全加固、渗透测试辅助,或提及 OWASP、安全检查、SQL 注入、XSS、代码审计、安全清单等关键词时触发此技能。 | rongxinzy/ | 154 | — | ~3k | Automated safety check: Pass | MIT | today |
| 799 | Optimize SQL query performance using EXPLAIN analysis, indexing strategies, and common anti-pattern fixes. | asgard-ai-platform/ | 241 | — | ~1.3k | Automated safety check: Pass | MIT | 4 mo ago |
| 800 | DataBrain intelligence data query assistant. An agent skill from infometa/workbuddyskills. | infometa/ | 342 | — | ~8k | Automated safety check: Pass | No licence | yesterday |
| 801 | 801.DB Performance Производительность БД и запросов 1С. An agent skill from IngvarConsulting/unica. | IngvarConsulting/ | 215 | — | ~920 | Automated safety check: Pass | Unknown | today |
| 802 | 802.Marimo Notebook marimo ノートブックを正しいフォーマットでPythonファイルに作成するスキル. An agent skill from minicoohei/ai-agent-camp. | minicoohei/ | 347 | — | ~1.5k | Automated safety check: Pass | No licence | today |
| 803 | 数据分析助手 - 专业的数据分析与业务洞察专家。适用场景: (1) 数据可视化与报表设计 (2) 业务指标体系构建 (3) 趋势分析与预测建模 (4) 异常检测与根因分析 (5) A/B测试设计与分析 (6) 数据报告撰写与汇报 (7) SQL/数据提取指导 触发关键词:数据分析、数据可视化、指标体系、趋势分析、异常检测、AB测试、数据报告、SQL、数据洞察、Dashboard、数据驱动 | chendongqi/ | 125 | — | ~1.1k | Automated safety check: Pass | No licence | 7 mo ago |
| 804 | 销售策略助手 - 专业的销售战略规划与执行优化专家。适用场景: (1) 销售战略规划与目标设定(年度/季度销售计划) (2) 客户画像与市场细分分析 (3) 销售渠道策略(直销/分销/电商/代理) (4) 定价策略与促销方案设计 (5) 销售团队架构与激励机制设计 (6) 竞争策略与差异化定位 (7) 大客户/KA销售策略 (8) 销售流程优化与漏斗管理… | chendongqi/ | 125 | — | ~1.6k | Automated safety check: Pass | No licence | 7 mo ago |
| 805 | 安全测试助手 - 专业的应用安全测试与防护专家。适用场景: (1) Web应用安全测试(OWASP Top 10漏洞检测) (2) API安全测试(认证/授权/数据泄露) (3) 安全测试用例设计与评审 (4) 渗透测试方案制定与执行指导 (5) 安全漏洞分析与风险评估 (6) 安全加固建议与最佳实践 (7) 安全合规检查(GDPR/等保) (8) 安全测试报告编写… | chendongqi/ | 125 | — | ~1.7k | Automated safety check: Pass | No licence | 7 mo ago |
| 806 | 806.Careful Blocks destructive shell commands once invoked: a PreToolUse Bash guard denies rm -rf outside temp dirs, force pushes and remote branch deletes, git reset --hard, DROP TABLE / DROP DATABASE /… | yonatangross/ | 288 | — | ~1.2k | Automated safety check: Pass | MIT | yesterday |
| 807 | 807.SQL Translator Translates a plain-English question into a single, safe, read-only SQL query against a known schema, with assumptions made explicit. | criptogus/ | 288 | — | ~735 | Automated safety check: Pass | CC-BY-SA-4.0 | 28 days ago |
| 808 | 808.Pp Obsidian Read-only Obsidian vault analytics CLI. An agent skill from mvanhorn/printing-press-library. | mvanhorn/ | 2.1k | — | ~2.3k | Automated safety check: Notes | Apache-2.0 | yesterday |
| 809 | 809.Pp Skool Every Skool community feature, plus a local SQLite mirror, FTS, and cross-community ops no other Skool tool ships. | mvanhorn/ | 2.1k | — | ~4k | Automated safety check: Notes | Apache-2.0 | yesterday |
| 810 | 面向 Ascend PyTorch Profiler / msprof DB(如 ascendpytorchprofiler.db、msprof.db)的 SQL 分析技能。将自然语言问题(算子耗时、通信、下发、调度、schema/table 查询)转为安全可执行 SQL,并按需从官方文档提取表结构详情。 | ascend-ai-coding/ | 174 | — | ~1.4k | Automated safety check: Pass | No licence | today |
| 811 | 811.DB Migration A skill your agent uses when setting up Alembic migrations or making database schema changes. | aiskillstore/ | 430 | — | ~2.3k | Automated safety check: Pass | No licence | today |
| 812 | Deploys PostgreSQL on Kubernetes using the CloudNativePG operator with automated failover. | aiskillstore/ | 430 | — | ~2k | Automated safety check: Pass | No licence | today |
| 813 | A skill your agent uses when designing database schemas, implementing repository patterns, writing optimized queries, managing migrations, or working with indexes and transactions for SQL/NoSQL… | MadAppGang/ | 283 | — | ~2.2k | Automated safety check: Pass | MIT | 6 mo ago |
| 814 | 814.Cloudflare 3 Manage Cloudflare Workers, KV, D1, R2, and secrets using the Wrangler CLI. | sundial-org/ | 663 | — | ~1.5k | Automated safety check: Pass | No licence | 7 mo ago |
| 815 | Set up Cloud Run Jobs with CloudSQL connection. An agent skill from divinevideo/divine-mobile. | divinevideo/ | 265 | — | ~1.4k | Automated safety check: Pass | MPL-2.0 | today |
| 816 | Fix psycopg2 "could not receive data from server: Operation timed out" or "connection already closed" errors when using Cloud SQL with long-running Python scripts. | divinevideo/ | 265 | — | ~1.1k | Automated safety check: Pass | MPL-2.0 | today |