sql-proUse when optimizing SQL queries, designing database schemas, or tuning database performance. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis.
Install via ClawdBot CLI:
clawdbot install Veeramanikandanr48/sql-proSenior SQL developer with mastery across major database systems, specializing in complex query design, performance optimization, and database architecture.
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.
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 |
When implementing SQL solutions, provide:
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
Generated Mar 1, 2026
Optimize queries for real-time sales dashboards involving complex joins across orders, products, and customers, using window functions for ranking and CTEs for aggregations. Ensure sub-100ms response times during peak traffic to support business decisions.
Design and tune SQL queries for generating regulatory reports with recursive CTEs for hierarchical data and window functions for time-series analysis. Focus on performance tuning to handle large transaction volumes while maintaining data accuracy.
Optimize database schemas and queries for patient records, using indexing strategies to speed up searches and CTEs for complex medical history aggregations. Ensure compliance with data privacy regulations through efficient query design.
Improve query performance for tracking shipments and optimizing delivery routes, leveraging window functions for analytics and covering indexes to reduce latency. Support real-time updates and scalability for high-volume logistics operations.
Tune SQL queries for analyzing user engagement data across multiple platforms, using CTEs for segmentation and window functions for trend analysis. Optimize for fast query execution to enable real-time insights and product improvements.
Offer specialized SQL optimization and database design services to businesses, charging per project or hourly rates for performance tuning, schema reviews, and query improvements. Revenue is generated through client contracts and ongoing support.
Integrate SQL Pro skills into a SaaS product that provides automated database performance monitoring and optimization tools. Revenue comes from subscription fees based on usage tiers and additional premium features for advanced analytics.
Develop and sell online courses, workshops, and certification programs focused on advanced SQL techniques and database performance tuning. Revenue is generated through course sales, corporate training packages, and certification exams.
💬 Integration Tip
Integrate with existing CI/CD pipelines to automate SQL query reviews and performance testing, ensuring consistent optimization across development stages.
Use the @steipete/oracle CLI to bundle a prompt plus the right files and get a second-model review (API or browser) for debugging, refactors, design checks, or cross-validation.
Manage Things 3 via the `things` CLI on macOS (add/update projects+todos via URL scheme; read/search/list from the local Things database). Use when a user asks Clawdbot to add a task to Things, list inbox/today/upcoming, search tasks, or inspect projects/areas/tags.
Local search/indexing CLI (BM25 + vectors + rerank) with MCP mode.
Use when designing database schemas, writing migrations, optimizing SQL queries, fixing N+1 problems, creating indexes, setting up PostgreSQL, configuring EF Core, implementing caching, partitioning tables, or any database performance question.
Connect to Supabase for database operations, vector search, and storage. Use for storing data, running SQL queries, similarity search with pgvector, and managing tables. Triggers on requests involving databases, vector stores, embeddings, or Supabase specifically.
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 slow queries. No ORMs required.