Skill rating
395 skills. The A–F grade combines safety (60%) and quality (40%); tests add a bonus. The rating refreshes automatically from open catalogs.
ManufacturingLogistics and warehouseProcurementQuality controlContact centreField serviceFinanceCustomer supportindustry shortcuts
| # | Grade | Skill | Score ▾ | Safety | Quality | Process | Tests | Popularity | Updated |
|---|---|---|---|---|---|---|---|---|---|
| 101 | A | Generate database schemas, migrations, and ERD diagrams from plain English descriptions — supports PostgreSQL, MySQL, SQLite, and MongoDB with proper indexes and constraints. | 100 | 75 | C | — | ↓ 1 578 | 11 May 2026 | |
| 102 | A | 大数据开发工程师级数据分析与SQL技能。(1)多数据引擎SQL编写(Hive/SparkSQL/Presto/ClickHouse/Doris/MySQL/PG/BigQuery)。(2)复杂SQL改造调试与性能优化。(3)数仓建模(ODS/DWD/DWS/ADS)维度设计/SCD变更。(4)数据探查/指标设计/ETL管线编排。(5)数据质量检测与异常分析。(6)SQL改写(方言迁移/语法适配)。 | 100 | 75 | C | — | ↓ 867 ★ 1 | 11 May 2026 | |
| 103 | A | LLM-powered intelligent data analysis assistant supporting natural language queries, SQL generation, visualization, and multi-turn conversation. Suitable for business analysis, report automation, and | 100 | 79 | C | — | ↓ 575 | 2 Jun 2026 | |
| 104 | B | MySQL数据库设计助手。根据业务规则文档和存量SQL DDL脚本,设计符合阿里巴巴规范的MySQL 5.7/8.0建表语句。当用户提到"数据库设计"、"建表语句"、"DDL"、"表结构设计"、"CREATE TABLE"等关键词时触发。支持读取业务规则文档(.md文件)、SQL脚本(.sql文件),输出遵循阿里云RDS规范的数据库表设计。 | 100 | 72 | C | — | ↓ 1 208 ★ 1 | 11 May 2026 | |
| 105 | A | Diagnose and manage Alibaba Cloud databases through natural language. Use when users need to troubleshoot database performance issues (high CPU, slow queries, abnormal connections, lock waits), check | 100 | 100 | B | — | — | 10 Jul 2026 | |
| 106 | A | Provision a disposable MySQL-compatible database instantly for free, no auth required. Includes a claim URL to convert Zero instances into regular TiDB Starter instances. | 100 | 76 | C | — | ↓ 1 105 | 11 May 2026 | |
| 107 | A | Database migration manager. Detects ORM/migration tool in use, generates migrations, handles rollbacks, creates seed scripts, diffs schemas between environments, backs up databases, and supports zero- | 100 | 77 | C | — | ↓ 664 | 11 May 2026 | |
| 108 | B | Operational guide for managing Cloudways servers and applications, across one or several Cloudways accounts, via the official Cloudways MCP server (Cloudways' hosted MCP / Remote MCP, per their suppor | 93 | 84 | C | — | ↓ 1 493 ★ 1 | 2 d ago | |
| 109 | A | Generate realistic synthetic test data — relational JSON/CSV/SQL fixtures, seed data, and QA datasets — via the MockHero MCP server or REST API. Use when a task needs mock users, orders, invoices, or | 100 | 83 | C | — | ↓ 293 | 3 Jul 2026 | |
| 110 | A | alibabacloud-polardb-mysql-inspectionGeneratorMySQLData and analyticsInfrastructureClawHubAgent Skills Health inspection for Alibaba Cloud PolarDB MySQL instances, generating visual HTML reports.
Supports five inspection dimensions:
1. Resource Monitoring — CPU, memory, IOPS, connections usage trends ( | 95 | 91 | C | — | ↓ 291 | 25 Jun 2026 | |
| 111 | B | create-auth-skillGeneratorGitHubPostgreSQLSoftware developmentLeoYeAI/openclaw-master-skillsAgent Skills Skill for creating auth layers in TypeScript/JavaScript apps using Better Auth. | 100 | 67 | D | — | ★ 2 141 | 20 Jul 2026 | |
| 112 | A | Fast path for a minimal CloudBase Web + database demo (最小前后端 / 最小可用 fullstack / Lovable-like BaaS). Defaults to @cloudbase/js-sdk client CRUD (NoSQL app.database / PG app.rdb), MCP-only schema, previe | 100 | 82 | C | — | ↓ 253 | 41 d ago | |
| 113 | A | database-architectProcedurePostgreSQLMySQLInfrastructureSecuritymodbender/skill-library-mcpAgent Skills Expert database architect specializing in data layer design from scratch, technology selection, schema modeling, and scalable database architectures. Masters SQL/NoSQL/TimeSeries database selection, n | 100 | 87 | B | — | ★ 14 | 16 Jun 2026 | |
| 114 | A | Provision a disposable MySQL-compatible database instantly for free, no auth required. Use when the user needs a temporary database for prototyping, testing SQL, running demos, vector search, full-tex | 100 | 88 | C | — | ★ 14 | 16 Jun 2026 | |
| 115 | A | Comprehensive SQL query assistant for database operations, optimization, and troubleshooting. Use when Codex needs to write, debug, optimize, or explain SQL queries; analyze database schemas; or help | 100 | 88 | D | — | ★ 14 | 16 Jun 2026 | |
| 116 | A | Run safe read-only queries against MySQL or PostgreSQL for data inspection, reporting, and troubleshooting. Use when the user asks to read tables, inspect schema, count rows, sample data, or export qu | 100 | 87 | C | — | ★ 14 | 16 Jun 2026 | |
| 117 | A | Query project databases with automatic SSH tunnel management. Use when you need to execute SQL queries against configured databases, especially those accessible only via SSH tunnels. Automatically man | 100 | 87 | D | — | ★ 14 | 16 Jun 2026 | |
| 118 | A | 高级软件架构师级别的业务方案设计与后端技术落地。功能包括:(1) 工程分析 - 读取现有工程,分析代码结构、接口风格、数据模型;(2) 业务方案设计 - 需求分析、架构设计、技术选型、实施规划;(3) 流程图设计 - 业务流程图、状态机图、时序图、架构图;(4) 接口设计 - Go proto 风格的 gRPC/HTTP 接口;(5) 数据库设计 - MySQL 建表语句。触发词:业务方案、架构设 | 100 | 76 | D | — | ↓ 861 | 11 May 2026 | |
| 119 | A | Run online login brute-force and password spraying with THC Hydra. Use when a user asks to test the login strength of SSH/FTP/HTTP/SMB/RDP services they own, validate a credential list against a targe | 95 | 85 | C | — | ★ 150 | 3 d ago | |
| 120 | B | Universal database IDE CLI — query PostgreSQL, MySQL, SQLite, BigQuery, MongoDB with cost projection | 100 | 71 | C | — | ↓ 1 157 ★ 1 | 18 May 2026 | |
| 121 | B | MySQL 数据库操作技能。通过 mysql CLI 连接数据库,执行 SELECT 查询、INSERT/UPDATE/DELETE 增删改、批量 SQL 执行、事务控制、数据库/表管理、JSON 格式输出。适用场景:查用户数据、统计报表、数据导入导出、数据库巡检、表结构查看、远程连接、生产环境调试。触发关键词:MySQL、数据库查询、SQL 语句执行、连接数据库、查表、数据增删改、jdbc 连接 | 100 | 73 | D | — | ↓ 1 286 | 18 May 2026 | |
| 122 | B | Write correct MySQL queries with proper character sets, indexing, transactions, and production patterns. | 100 | 59 | C | — | ↓ 5 701 ★ 6 | 11 May 2026 | |
| 123 | A | Use when the user has tabular data (pandas DataFrame, parquet, csv, Arrow, json) and wants to filter, group, aggregate, join, or speed up slow pandas. Provides chDB DataStore — same pandas API, ClickH | 100 | 97 | C | — | — | 10 Jul 2026 | |
| 124 | B | Complete database schema reference for Teamgram Server with all 43 tables, ER relationships, and key table structure explanations for the MySQL teamgram database. | 100 | 72 | C | — | ↓ 1 030 | 11 May 2026 | |
| 125 | A | Orchestration skill for the codai-dev local environment. Routes user commands to the right plugin (proxy-manager, mysql-manager, postgres-manager, redis-manager, worktree-manager). Use when the user a | 100 | 76 | C | — | ↓ 616 | 11 May 2026 | |
| 126 | A | sql-index-optimizer-multi-dbGeneratorPostgreSQLMySQLInfrastructureSoftware developmentClawHubAgent Skills 当用户希望“通过建表语句 + 慢 SQL 自动优化索引”时使用此 Skill,支持 MySQL、Oracle、PostgreSQL。脚本使用 Python,自动解析 DDL 与慢 SQL 中的 WHERE/JOIN/ORDER BY 列,生成候选索引及对应数据库的 CREATE INDEX 语句,并输出到文件。 | 100 | 75 | C | — | ↓ 591 | 11 May 2026 | |
| 127 | B | 个人健身跟踪器 — 通过文字记录健身训练数据,自动解析动作、组数、次数和重量,实时写入本地 MySQL 数据库。支持制定专属训练计划、查询历史记录、追踪进步曲线,以及球类和有氧运动记录。 | 100 | 70 | D | — | ↓ 914 ★ 1 | 11 May 2026 | |
| 128 | B | system-data-intelligenceIntegrationPostgreSQLMySQLData and analyticsInfrastructureClawHubAgent Skills 专为文件操作、数据分析、可视化、数据库连接、API 接入和敏感数据处理设计的系统级 Agent Skill。
【强制触发场景】: - 用户提及任何文件操作:Excel / WPS / Word / TXT / Markdown / RTZ / CSV / JSON - 「分析」「读取」「提取」「处理」「建模」「预测」「异常检测」 - 「生成图表」「可视化」「做仪表盘」「出报告」 - 「连数据库」「 | 100 | 70 | F | — | ↓ 1 589 | 18 May 2026 | |
| 129 | A | Execute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures. Use when migrating databases, changing schemas, performing data trans | 100 | 84 | B | — | ★ 14 | 16 Jun 2026 | |
| 130 | A | Query, design, migrate, and optimize SQL databases. Use when working with SQLite, PostgreSQL, or MySQL — schema design, writing queries, creating migrations, indexing, backup/restore, and debugging sl | 100 | 84 | D | — | ★ 14 | 16 Jun 2026 | |
| 131 | B | BIC-QA 数据库与操作系统知识库问答(支持多轮上下文)。当用户提出数据库(Oracle/MySQL/PostgreSQL/达梦/金仓/GaussDB/Redis/MongoDB 等)或操作系统相关的原理、运维、故障排查、性能优化问题,或需要基于 BIC-QA 知识库检索权威资料时使用。同一话题的连续追问必须复用会话。 | 95 | 79 | D | — | ↓ 894 | 4 d ago | |
| 132 | B | 生成 Docker Compose 配置,支持 MySQL, PostgreSQL, Redis, MongoDB, Elasticsearch 等常用服务。 | 100 | 69 | C | — | ↓ 1 448 | 17 May 2026 | |
| 133 | B | Natural language to SQL. Ask questions about your data in plain English, get queries, results, and explanations. Supports SQLite, PostgreSQL, and MySQL. Import CSVs for instant ad-hoc analysis. Save f | 100 | 67 | C | — | ↓ 1 266 ★ 1 | 17 May 2026 | |
| 134 | B | 生成完整的男装电商系统项目,技术栈为 SpringBoot3 + Vue3 + MySQL。执行流程:先输出详细技术方案供用户确认,确认后再分模块生成完整的前后端代码。使用场景:当用户需要创建一个完整的男装电商平台,包括商品管理、用户管理、订单管理、购物车、支付集成等功能时使用此技能。 | 100 | 73 | C | — | ↓ 748 | 11 May 2026 | |
| 135 | B | 使用火山引擎 RDS MySQL MCP Server,帮助用户完成 RDS MySQL 相关的实例管理、数据库操作、账号管理和运维任务,可直接调用 uv run ./scripts/call_rds_mysql.py 脚本获取实时结果。 | 100 | 72 | C | — | ↓ 738 | 11 May 2026 | |
| 136 | B | Prometheus + Grafana 监控方案,专为**单台物理机部署多个 Java 游戏进程 + 自建 MySQL**的场景设计。Java 进程通过 jstat/jcmd 无侵入采集 JVM 运行时指标(堆内存、新生代、老年代、GC、线程、类内存),MySQL 通过 pymysql 采集(Buffer Pool、进程内存)。监控重点围绕**内存使用率**,适配游戏服高频 GC 和大内存占用的 | 99 | 74 | C | — | ↓ 754 | 11 May 2026 | |
| 137 | A | Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.). Use when setting up a new project, changing databases, or troubleshooting connection issues. | 100 | 94 | C | — | — | 10 Jul 2026 | |
| 138 | A | Complete migration guide from Prisma ORM v6 to v7 covering all breaking changes. Use when upgrading Prisma versions, encountering v7 errors, or migrating existing projects. Triggers on "upgrade to pri | 100 | 94 | C | — | — | 10 Jul 2026 | |
| 139 | B | query store order information from database | 100 | 69 | C | — | ↓ 1 163 | 11 May 2026 | |
| 140 | B | Python-based database connectivity skill supporting MySQL, PostgreSQL, Oracle, SQL Server, and SQLite. Provides connection management, parameterized query execution, schema introspection, and transact | 100 | 70 | C | — | ↓ 1 125 | 18 May 2026 | |
| 141 | A | Report the health, performance, resource status, and actual billed cost of an application deployed by qwencloud-deploy to Alibaba Cloud International (alibabacloud.com), in plain language and without | 95 | 89 | C | — | ↓ 71 | 20 h ago | |
| 142 | A | AutoTable 框架完整使用指南。基于 JDBC 的自动建表框架(非 MyBatis 依赖),支持 9 种数据库。覆盖注解配置、多数据库适配、生命周期钩子、SPI 扩展、SQL 审计、数据初始化、多数据源等。当用户询问 AutoTable 的用法、注解、配置、扩展、最佳实践时激活。 | 100 | 75 | C | — | ↓ 354 | 9 Jun 2026 | |
| 143 | B | sql-query-generatorAnalyzerPostgreSQLMySQLSoftware developmentLeoYeAI/openclaw-master-skillsAgent Skills Generate secure SQL queries with validation, pagination helpers, risk analysis, and audit-focused safeguards. | 100 | 62 | C | — | ★ 2 141 | 20 Jul 2026 | |
| 144 | A | 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 inj | 99 | 84 | C | — | ★ 14 | 16 Jun 2026 | |
| 145 | A | Profile and optimize application performance. Use when diagnosing slow code, measuring CPU/memory usage, generating flame graphs, benchmarking functions, load testing APIs, finding memory leaks, or op | 100 | 82 | D | — | ★ 14 | 16 Jun 2026 | |
| 146 | A | 面向独立开发者与AI Agent的SQL查询执行工具免费版。聚焦命令行场景下的关系型数据库查询、参数化执行、执行计划分析与跨数据库可移植性,提供经过实战检验的查询模式、索引陷阱清单与EXPLAIN解读方法,帮助用户在不依赖重量级ORM的前提下高效完成数据访问任务。Use when 需要数据库操作、SQL查询、数据存储管理时使用。不适用于数据库架构设计决策. | 100 | 76 | C | — | ↓ 506 | 26 Jul 2026 | |
| 147 | B | You are an expert in Drizzle ORM, the lightweight TypeScript ORM that maps directly to SQL. You help developers write type-safe database queries that look like SQL (not a new query language), generate | 100 | 73 | C | — | ★ 150 | 3 d ago | |
| 148 | B | Expert guidance for PlanetScale, the serverless MySQL platform built on Vitess (the database clustering system powering YouTube). Helps developers set up databases with Git-like branching for schema c | 100 | 73 | C | — | ★ 150 | 3 d ago | |
| 149 | B | You are an expert in MikroORM, the TypeScript ORM built on Unit of Work and Identity Map patterns. You help developers build data layers with decorator-based entities, automatic change tracking, lazy/ | 100 | 73 | C | — | ★ 150 | 3 d ago | |
| 150 | B | Manage Amazon RDS for fully managed relational databases. Provision MySQL,
PostgreSQL, and Aurora instances with automated backups and patching. Configure
read replicas for scaling, snapshots for reco | 100 | 73 | C | — | ★ 150 | 3 d ago |