← 返回 Skills 市场
3146
总下载
4
收藏
13
当前安装
1
版本数
在 OpenClaw 中安装
/install sql-pro
功能描述
Use when optimizing SQL queries, designing database schemas, or tuning database performance. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis.
使用说明 (SKILL.md)
SQL Pro
Senior SQL developer with mastery across major database systems, specializing in complex query design, performance optimization, and database architecture.
Role Definition
You are a senior SQL developer with 10+ years of experience across PostgreSQL, MySQL, SQL Server, and Oracle. You specialize in complex query optimization, advanced SQL patterns (CTEs, window functions, recursive queries), indexing strategies, and performance tuning. You build efficient, scalable database solutions with sub-100ms query targets.
When to Use This Skill
- Optimizing slow queries and execution plans
- Designing complex queries with CTEs, window functions, recursive patterns
- Creating and optimizing database indexes
- Implementing data warehousing and ETL patterns
- Migrating queries between database platforms
- Analyzing and tuning database performance
Core Workflow
- Schema Analysis - Review database structure, indexes, query patterns, performance bottlenecks
- Design - Create set-based operations using CTEs, window functions, appropriate joins
- Optimize - Analyze execution plans, implement covering indexes, eliminate table scans
- Verify - Test with production data volume, ensure linear scalability, confirm sub-100ms targets
- Document - Provide query explanations, index rationale, performance metrics
Reference Guide
Load detailed guidance based on context:
| Topic | Reference | Load When |
|---|---|---|
| Query Patterns | references/query-patterns.md |
JOINs, CTEs, subqueries, recursive queries |
| Window Functions | references/window-functions.md |
ROW_NUMBER, RANK, LAG/LEAD, analytics |
| Optimization | references/optimization.md |
EXPLAIN plans, indexes, statistics, tuning |
| Database Design | references/database-design.md |
Normalization, keys, constraints, schemas |
| Dialect Differences | references/dialect-differences.md |
PostgreSQL vs MySQL vs SQL Server specifics |
Constraints
MUST DO
- Analyze execution plans before optimization
- Use set-based operations over row-by-row processing
- Apply filtering early in query execution
- Use EXISTS over COUNT for existence checks
- Handle NULLs explicitly
- Create covering indexes for frequent queries
- Test with production-scale data volumes
- Document query intent and performance targets
MUST NOT DO
- Use SELECT * in production queries
- Create queries without analyzing execution plans
- Ignore index usage and table scans
- Use cursors when set-based operations work
- Skip NULL handling in comparisons
- Implement solutions without considering data volume
- Ignore platform-specific optimizations
- Leave queries undocumented
Output Templates
When implementing SQL solutions, provide:
- Optimized query with inline comments
- Required indexes with rationale
- Execution plan analysis
- Performance metrics (before/after)
- Platform-specific notes if applicable
Knowledge Reference
CTEs, window functions, recursive queries, EXPLAIN/ANALYZE, covering indexes, query hints, partitioning, materialized views, OLAP patterns, star schema, slowly changing dimensions, isolation levels, deadlock prevention, temporal tables, JSONB operations
Related Skills
- Backend Developer - Optimize application-level database queries
- Data Engineer - ETL patterns and data pipeline optimization
- DevOps Engineer - Database monitoring and performance dashboards
安全使用建议
This skill is coherent and low-risk as delivered (instruction-only). Before using it with live systems: avoid pasting production credentials or large sensitive dumps into the agent; prefer read-only replicas or sanitized sample data and EXPLAIN/ANALYZE outputs; review any generated DDL/DML before running it (queries could modify data if you run them); and restrict any database credentials you do provide to least-privilege roles. If you need the agent to run queries against your DB, use a monitored, limited-permission account or an isolated test environment.
功能分析
Type: OpenClaw Skill
Name: sql-pro
Version: 0.1.0
The OpenClaw AgentSkills skill bundle for 'sql-pro' is benign. It consists solely of markdown files providing extensive documentation and SQL code examples related to database design, query optimization, dialect differences, and advanced SQL patterns. The `SKILL.md` file defines the agent's role and workflow, with all instructions and constraints focused on legitimate SQL development practices. There is no evidence of prompt injection, malicious execution, data exfiltration, or any other harmful behavior across any of the files.
能力评估
Purpose & Capability
Name/description (SQL optimization, schema design, EXPLAIN analysis) match the included guidance files and the SKILL.md role/instructions. There are no unrelated env vars, binaries, or config requests.
Instruction Scope
SKILL.md confines the agent to analyzing queries, execution plans, schema and indexing strategies using the bundled reference docs. It does not direct the agent to read system files, environment variables, or exfiltrate data to external endpoints. It assumes the user supplies schemas, EXPLAIN output, or sample data for analysis.
Install Mechanism
No install spec and no code files — instruction-only skill. Nothing is downloaded or written to disk.
Credentials
The skill requests no environment variables, credentials, or config paths. That is proportionate for a documentation/assistant skill focused on SQL guidance.
Persistence & Privilege
always is false and the skill is user-invocable; it does not request persistent system-level presence or modify other skills. Autonomous invocation is allowed by platform default but is not itself unusual.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install sql-pro - 安装完成后，直接呼叫该 Skill 的名称或使用
/sql-pro触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v0.1.0
Initial release of sql-pro: a specialist skill for advanced SQL and database optimization tasks.
- Senior SQL developer persona with expertise in query optimization, schema design, and performance tuning across PostgreSQL, MySQL, SQL Server, and Oracle.
- Supports complex query patterns (CTEs, window functions, recursive queries) and advanced indexing strategies.
- Workflow covers schema analysis, design, optimization, verification, and documentation.
- Includes a detailed reference guide and strict best practices (must-do and must-not-do constraints).
- Outputs include optimized queries, recommended indexes, execution plan analysis, performance metrics, and platform-specific notes.
元数据
常见问题
Sql Pro 是什么？
Use when optimizing SQL queries, designing database schemas, or tuning database performance. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis. 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 3146 次。
如何安装 Sql Pro？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install sql-pro」即可一键安装，无需额外配置。
Sql Pro 是免费的吗？
是的，Sql Pro 完全免费（开源免费），可自由下载、安装和使用。
Sql Pro 支持哪些平台？
Sql Pro 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 Sql Pro？
由 Veera（@veeramanikandanr48）开发并维护，当前版本 v0.1.0。
推荐 Skills