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.
Why use this skill?
Optimize your SQL queries, design complex schemas, and tune database performance with SQL Pro. Master CTEs, window functions, and indexing strategies with ease.
Install via CLI (Recommended)
clawhub install openclaw/skills/skills/veeramanikandanr48/sql-proWhat This Skill Does
SQL Pro acts as your senior-level database engineer, providing deep expertise in query optimization, relational database architecture, and performance tuning. It helps developers move beyond simple CRUD operations to master set-based logic, advanced analytic functions, and complex query plans. Whether you are dealing with massive datasets in PostgreSQL, legacy constraints in Oracle, or performance bottlenecks in MySQL, this agent provides the architectural oversight needed to maintain sub-100ms response times. The skill enforces industry best practices by requiring execution plan analysis, strategic indexing, and the replacement of inefficient row-by-row processing with high-performance relational patterns.
Installation
To integrate this skill into your OpenClaw environment, execute the following command in your terminal:
clawhub install openclaw/skills/skills/veeramanikandanr48/sql-pro
Use Cases
SQL Pro is essential for:
- Performance Tuning: Diagnosing slow-running queries by analyzing EXPLAIN plans and identifying unnecessary table scans.
- Complex Logic: Building sophisticated reports using Window Functions (RANK, LAG/LEAD, NTILE) and Recursive CTEs for hierarchical data structures.
- Schema Design: Architecting normalized schemas that balance data integrity with query performance through judicious use of constraints, indexes, and partitioning.
- Migration: Translating T-SQL or PL/SQL procedures into high-performance, dialect-agnostic or platform-optimized queries.
- Data Engineering: Designing efficient ETL workflows that leverage set-based operations to minimize I/O overhead.
Example Prompts
- "Analyze this slow execution plan for my customer transactions table; it's currently performing a full table scan and taking 5 seconds to run. Suggest a covering index strategy."
- "I need to calculate a 3-month moving average of sales per region using Window Functions in PostgreSQL. How can I structure this for maximum performance?"
- "Convert this recursive stored procedure into a single, efficient Common Table Expression (CTE) to improve readability and performance."
Tips & Limitations
- Always provide context: When asking for optimization, include your schema definition and the current execution plan for the best results.
- Data volume matters: The agent is designed for production-scale data; if you are testing with tiny datasets, index recommendations might be skewed.
- *No "SELECT ": The agent is configured to reject wildcard selections in production to reduce network overhead and ensure index coverage.
- Safety first: Always run schema changes in a staging environment before applying them to production, even when the agent provides optimized syntax.
Metadata
Not sure this is the right skill?
Describe what you want to build — we'll match you to the best skill from 16,000+ options.
Find the right skillPaste this into your clawhub.json to enable this plugin.
{
"plugins": {
"official-veeramanikandanr48-sql-pro": {
"enabled": true,
"auto_update": true
}
}
}Tags(AI)
Flags: code-execution
Related Skills
better-auth
Self-hosted auth for TypeScript/Cloudflare Workers with social auth, 2FA, passkeys, organizations, RBAC, and 15+ plugins. Requires Drizzle ORM or Kysely for D1 (no direct adapter). Self-hosted alternative to Clerk/Auth.js. Use when: self-hosting auth on D1, building OAuth provider, multi-tenant SaaS, or troubleshooting D1 adapter errors, session caching, rate limits, Expo crashes, additionalFields bugs.
security-reviewer
Use when conducting security audits, reviewing code for vulnerabilities, or analyzing infrastructure security. Invoke for SAST scans, penetration testing, DevSecOps practices, cloud security reviews.
api-designer
Use when designing REST or GraphQL APIs, creating OpenAPI specifications, or planning API architecture. Invoke for resource modeling, versioning strategies, pagination patterns, error handling standards.
cli-developer
Use when building CLI tools, implementing argument parsing, or adding interactive prompts. Invoke for CLI design, argument parsing, interactive prompts, progress indicators, shell completions.
swift-expert
Use when building iOS/macOS applications with Swift 5.9+, SwiftUI, or async/await concurrency. Invoke for protocol-oriented programming, SwiftUI state management, actors, server-side Swift.