← Back to Skills Marketplace
3146
Downloads
4
Stars
13
Active Installs
1
Versions
Install in OpenClaw
/install sql-pro
Description
Use when optimizing SQL queries, designing database schemas, or tuning database performance. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis.
README (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
Usage Guidance
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.
Capability Analysis
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.
Capability Assessment
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.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install sql-pro - After installation, invoke the skill by name or use
/sql-pro - Provide required inputs per the skill's parameter spec and get structured output
Version History
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.
Metadata
Frequently Asked Questions
What is 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. It is an AI Agent Skill for Claude Code / OpenClaw, with 3146 downloads so far.
How do I install Sql Pro?
Run "/install sql-pro" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is Sql Pro free?
Yes, Sql Pro is completely free (open-source). You can download, install and use it at no cost.
Which platforms does Sql Pro support?
Sql Pro is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created Sql Pro?
It is built and maintained by Veera (@veeramanikandanr48); the current version is v0.1.0.
More Skills