sql-databases
33
clickhouse-architect
ClickHouse schema design and optimization. TRIGGERS - ClickHouse schema, compression codecs, MergeTree, ORDER BY tuning, partition key.
terrylica
databases
sorting
stars
current ordering strategy
query
all entries
refine the visible subset
sql-databases
33
clickhouse-cloud-management
ClickHouse Cloud user and permission management. TRIGGERS - create ClickHouse user, ClickHouse permissions, ClickHouse Cloud credentials.
terrylica
databases
sql-databases
33
multi-agent-e2e-validation
Multi-agent parallel E2E validation for database refactors. TRIGGERS - E2E validation, schema migration testing, database refactor validation.
terrylica
databases
sql-databases
33
supabase-schema
Supabase declarative schema workflow. Use when modifying database schemas, creating migrations, or working with PostgreSQL types. Covers the stop-edit-diff-start cycle.
0xsend
databases
sql-databases
33
sql-patterns
Advanced SQL patterns including window functions, CTEs, recursive queries, and optimization techniques.
majesticlabs-dev
databases
sql-databases
33
store-model-coder
Wrap JSON-backed database columns with ActiveModel-like classes using store_model. Use when creating configuration objects, managing nested JSON attributes, or adding validations to JSON data. Triggers on JSON columns, store_model, typed JSON, configuration objects, or nested attributes.
majesticlabs-dev
databases
sql-databases
33
database-management
Database schema design, migrations, query optimization, and ORM best practices. Use for database setup, performance tuning, and data modeling.
Sir-chawakorn
databases
sql-databases
33
imessage-query
Query macOS iMessage database (chat.db) via SQLite. Decode NSAttributedString messages, handle tapbacks, search conversations. TRIGGERS - imessage, chat.db, messages database, text messages, iMessage history, NSAttributedString, attributedBody
terrylica
databases
sql-databases
33
sqlalchemy-patterns
SQLAlchemy 2.0 patterns - model definition, engine setup, async patterns, relationships, query optimization, repository pattern, and transactions.
majesticlabs-dev
databases
sql-databases
32
cloud-sql-postgres-view-config
Use these skills when you need to discover and manage PostgreSQL extensions or fine-tune engine-level settings such as memory allocation and server configuration parameters.
gemini-cli-extensions
databases
sql-databases
32
cloud-sql-postgres-data
Use these skills when you need to explore the database structure, discover schema objects like views or stored procedures, and execute custom SQL queries to interact with your data.
gemini-cli-extensions
databases
sql-databases
32
obelisk-urql
The urql obelisk database scripting language is a dialect of sql. There are a few significant differences.
jackfoxy
databases
sql-databases
32
add-sql-function
How to implement a new SQL feature in squirreling.
hyparam
databases
sql-databases
31
dbt-materializations
Choosing and implementing dbt materializations (ephemeral, view, table, incremental, snapshots, Python models). Use this skill when deciding on materialization strategy, implementing incremental models, setting up snapshots for SCD Type 2 tracking, or creating Python models for machine learning workloads.
sfc-gh-dflippo
databases
sql-databases
31
query-optimize
Guidance for SQL query optimization tasks. This skill should be used when optimizing slow SQL queries, improving database performance, or rewriting queries to be more efficient. Covers query plan analysis, benchmarking strategies, and database-specific optimization techniques.
letta-ai
databases
sql-databases
31
query-optimize
This skill provides guidance for SQL query optimization tasks, including rewriting slow queries for better performance while preserving semantic equivalence. Use this skill when asked to optimize, improve performance of, or rewrite SQL queries, particularly when dealing with correlated subqueries, complex joins, or queries that need CTEs/window functions.
letta-ai
databases
sql-databases
31
dbt-artifacts
Monitor dbt execution using the dbt Artifacts package. Use this skill when you need to track test and model execution history, analyze run patterns over time, monitor data quality metrics, or enable programmatic access to dbt execution metadata across any dbt version or platform.
sfc-gh-dflippo
databases
sql-databases
31
dbt-projects-on-snowflake
Deploying, managing, executing, and monitoring dbt projects natively within Snowflake using dbt PROJECT objects and event tables. Use this skill when you want to set up dbt development workspaces, deploy projects to Snowflake, schedule automated runs, monitor execution with event tables, or enable team collaboration directly in Snowflake.
sfc-gh-dflippo
databases
sql-databases
31
dbt-performance
Optimizing dbt and Snowflake performance through materialization choices, clustering keys, warehouse sizing, and query optimization. Use this skill when addressing slow model builds, optimizing query performance, sizing warehouses, implementing clustering strategies, or troubleshooting performance issues.
sfc-gh-dflippo
databases
sql-databases
31
dbt-modeling
Writing dbt models with proper CTE patterns, SQL structure, and layer-specific templates. Use this skill when writing or refactoring dbt models, implementing CTE patterns, creating staging/intermediate/mart models, or ensuring proper SQL structure and dependencies.
sfc-gh-dflippo
databases
sql-databases
31
dbt-testing
dbt testing strategies using dbt_constraints for database-level enforcement, generic tests, and singular tests. Use this skill when implementing data quality checks, adding primary/foreign key constraints, creating custom tests, or establishing comprehensive testing frameworks across bronze/silver/gold layers.
sfc-gh-dflippo
databases
sql-databases
31
schemachange
Deploying and managing Snowflake database objects using version control with schemachange. Use this skill when you need to manage database migrations for objects not handled by dbt, implement CI/CD pipelines for schema changes, or coordinate deployments across multiple environments.
sfc-gh-dflippo
databases
sql-databases
31
dbt-projects-snowflake-setup
Step-by-step setup guide for dbt Projects on Snowflake including prerequisites, external access integration, Git API integration, event table configuration, and automated scheduling. Use this skill when setting up dbt Projects on Snowflake for the first time or troubleshooting setup issues.
sfc-gh-dflippo
databases