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
earnings-calendar
This skill retrieves upcoming earnings announcements for US stocks using the Financial Modeling Prep (FMP) API. Use this when the user requests earnings calendar data, wants to know which companies are reporting earnings in the upcoming week, or needs a weekly earnings review. The skill focuses on mid-cap and above companies (over $2B market cap) that have significant market impact, organizing the data by date and timing in a clean markdown table format. Supports multiple environments (CLI, Desktop, Web) with flexible API key management.
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.
dividend-growth-pullback-screener
Use this skill to find high-quality dividend growth stocks (12%+ annual dividend growth, 1.5%+ yield) that are experiencing temporary pullbacks, identified by RSI oversold conditions (RSI ≤40). This skill combines fundamental dividend analysis with technical timing indicators to identify buying opportunities in strong dividend growers during short-term weakness.
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.
options-strategy-advisor
Options trading strategy analysis and simulation tool. Provides theoretical pricing using Black-Scholes model, Greeks calculation, strategy P/L simulation, and risk management guidance. Use when user requests options strategy analysis, covered calls, protective puts, spreads, iron condors, earnings plays, or options risk management. Includes volatility analysis, position sizing, and earnings-based strategy recommendations. Educational focus with practical trade simulation.