window-functions-deep-dive
Master OPAL window functions for row-relative calculations, rankings, and moving aggregates. Covers lag(), lead(), row_number(), rank(), dense_rank(), moving averages, first(), and last(). Use when comparing rows to neighbors, ranking within partitions, calculating rate of change, or computing time-based moving windows. CRITICAL - OPAL uses window() function wrapper, NOT SQL OVER clause.
sql-query
Generate and optimize SQL queries for data retrieval and analysis
snowflake-semantic-views
Create, alter, and validate Snowflake semantic views using Snowflake CLI (snow). Use when asked to build or troubleshoot semantic views/semantic layer definitions with CREATE/ALTER SEMANTIC VIEW, to validate semantic-view DDL against Snowflake via CLI, or to guide Snowflake CLI installation and connection setup.
database-integration
Database integration - schema design, queries, migrations, optimization
database-assistant
Activates when user needs help with database design, SQL queries, migrations, or ORM usage. Triggers on "database schema", "SQL query", "migration", "optimize query", "foreign key", "index", "normalize", "ORM", "Prisma", "TypeORM", "SQLAlchemy", or database-related questions.
sql-optimization-patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.
vector-databases
Vector database selection, indexing strategies, and semantic search optimization.
database-patterns
Database design, optimization, and caching strategies for SQL, NoSQL, and Redis
aws-rds-setup
Deploy and configure RDS/Aurora databases with HA and security
data-warehousing
Master dimensional data modeling including star schema design, slowly changing dimensions, fact tables, and data warehouse architecture
sql-databases
SQL query optimization, schema design, indexing strategies, and relational database mastery for production data systems
nosql-databases
MongoDB, Redis, Cassandra, DynamoDB, and distributed database patterns for scalable applications
data-warehousing
Snowflake, BigQuery, Redshift, dimensional modeling, and modern data warehouse architecture
go-database
Go database operations - SQL, ORMs, transactions, migrations
php-database
PHP database mastery - PDO, Eloquent, Doctrine, query optimization, and migrations
postgresql-performance
Optimize PostgreSQL performance - EXPLAIN ANALYZE, indexing, query tuning
postgresql-fundamentals
Master PostgreSQL SQL fundamentals - data types, tables, constraints, schema design
postgresql-docker
PostgreSQL in containers - Docker, Kubernetes, production configs
Page 3 of 13 · 231 results