Optimize SQL Queries and Database Performance
Expert SQL across cloud-native, HTAP, and OLAP platforms: query optimization, dimensional modeling, and security.
Why it matters
Master modern database systems, optimize complex SQL queries, and design high-performance data architectures for cloud-native and hybrid environments.
Outcomes
What it gets done
Tune query performance using indexes and execution plans
Design efficient SQL patterns for OLTP/OLAP workloads
Analyze and optimize complex analytical queries
Implement advanced indexing strategies
Install
Add it to your toolbox
Run in your project directory:
curl -fsSL https://spark.entire.vc/get/ag-sql-pro | bash Overview
Sql Pro
Provides expert SQL across cloud-native, HTAP, and OLAP platforms, covering query optimization, dimensional modeling, and security. Use when writing complex SQL, tuning query performance, or designing OLTP/OLAP database patterns.
What it does
Provides expert SQL specialization across modern database systems, performance optimization, and advanced analytical techniques spanning cloud-native, hybrid OLTP/OLAP (HTAP), and data warehouse environments.
When to use - and when NOT to
Use this skill when writing complex SQL queries or analytics, tuning query performance with indexes or execution plans, or designing SQL patterns for OLTP/OLAP workloads. Not a fit when only ORM-level guidance is needed, the system is non-SQL or document-only, or query plans and schema details aren't accessible. Before running heavy exploratory queries against production, use read replicas or limits rather than querying live production directly.
Inputs and outputs
The response approach defines query goals and constraints, inspects schema/statistics/access paths, optimizes and validates with EXPLAIN, and verifies correctness and performance under realistic load. Platform coverage spans cloud-native databases (Aurora, Cloud SQL, Azure SQL), data warehouses (Snowflake, BigQuery, Redshift, Databricks), hybrid OLTP/OLAP systems (CockroachDB, TiDB, MemSQL, VoltDB), NoSQL-with-SQL-interface systems (MongoDB, Cassandra, DynamoDB), time-series (InfluxDB, TimescaleDB, Druid), and graph databases (Neo4j, Neptune).
Advanced query technique coverage includes window functions, recursive CTEs for hierarchical data, advanced JOIN optimization, parallel query processing and partitioning, and JSON/XML processing. Performance tuning covers index strategy design, execution plan analysis, statistics management, table partitioning for time-series and large tables, connection pooling, and memory/buffer pool configuration. Data modeling coverage spans normalization/denormalization tradeoffs, dimensional modeling (star/snowflake schemas), Slowly Changing Dimensions, data vault modeling, and event sourcing/CQRS patterns for microservices.
Modern SQL feature coverage includes ANSI SQL 2016+ row pattern recognition, temporal tables and time-travel queries, and full-text/spatial data handling. Analytics coverage spans OLAP cube design, cohort analysis and customer segmentation, time-series forecasting, and ML integration with SQL. Security coverage includes row-level security, column-level encryption, data masking, audit trails, RBAC, SQL injection prevention, and GDPR compliance. DevOps coverage includes database CI/CD, schema migration and version control, and performance benchmarking. Integration coverage spans ETL/ELT design, CDC-based real-time streaming, cross-database federation, and event-driven database triggers.
Integrations
Spans cloud-native databases (Aurora, Cloud SQL, Azure SQL), data warehouses (Snowflake, BigQuery, Redshift, Databricks), HTAP systems (CockroachDB, TiDB), time-series (TimescaleDB, InfluxDB, Druid), and graph databases (Neo4j, Neptune) - applying the appropriate SQL dialect and optimization approach per platform.
Who it's for
Database engineers and analysts working across cloud-native, HTAP, and OLAP platforms who need platform-specific SQL optimization, dimensional modeling, and security compliance guidance rather than generic single-dialect SQL help.
-- billion-row Snowflake query optimization, cohort analysis, HTAP schema design
EXPLAIN ANALYZE SELECT ...
FAQ
Common questions
Discussion
Questions & comments · 0
Sign In Sign in to leave a comment.