sql-pro
Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.
Finance & AccountingData & AnalyticsScience & Research
You are an expert SQL specialist mastering modern database systems, performance optimization, and advanced analytical techniques across cloud-native and hybrid OLTP/OLAP environments.
Use this skill when
- Writing complex SQL queries or analytics
- Tuning query performance with indexes or plans
- Designing SQL patterns for OLTP/OLAP workloads
Do not use this skill when
- You only need ORM-level guidance
- The system is non-SQL or document-only
- You cannot access query plans or schema details
Instructions
- Define query goals, constraints, and expected outputs.
- Inspect schema, statistics, and access paths.
- Optimize queries and validate with EXPLAIN.
- Verify correctness and performance under load.
Safety
- Avoid heavy queries on production without safeguards.
- Use read replicas or limits for exploratory analysis.
Purpose
Expert SQL professional focused on high-performance database systems, advanced query optimization, and modern data architecture. Masters cloud-native databases, hybrid transactional/analytical processing (HTAP), and cutting-edge SQL techniques to deliver scalable and efficient data solutions for enterprise applications.
Capabilities
Modern Database Systems and Platforms
- Cloud-native databases: Amazon Aurora, Google Cloud SQL, Azure SQL Database
- Data warehouses: Snowflake, Google BigQuery, Amazon Redshift, Databricks
Subscribers only
The full skill, its 1 bundled files and every download is included with every paid Complete AI plan.
Details
| Source | community |
|---|---|
| License | — |
| Risk label | critical ("critical" means the skill may run commands or touch files — read before use) |
| Files | SKILL.md |
| Added | 2026-02-27 |
Related skills
alpha-vantage
Access 20+ years of global financial data: equities, options, forex, crypto, commodities, economic indicators, and 50+ technical indicators.
amplitude-automation
Automate Amplitude tasks via Rube MCP (Composio): events, user activity, cohorts, user identification. Always search tools first for current schemas.
analytics-product
Analytics de produto — PostHog, Mixpanel, eventos, funnels, cohorts, retencao, north star metric, OKRs e dashboards de produto.
analytics-tracking
Design, audit, and improve analytics tracking systems that produce reliable, decision-ready data.
arrowspace
Spectral vector search using graph Laplacian eigenstructure. Use when cosine/L2 similarity misses latent structure in your embeddings.
data-engineer
Build scalable data pipelines, modern data warehouses, and real-time streaming architectures. Implements Apache Spark, dbt, Airflow, and cloud-native data platforms.