Sql skills

This skill guides you to create reversible, well-named migrations with zero-downtime deployment strategies and safe data transformations.

This skill helps you build persistent, stateful AI agents on Cloudflare Workers, enabling scheduling, RPC, and streaming chat with Code Mode benefits.

This skill helps you design, review, and test Cloudflare Durable Objects for stateful coordination, RPC, and durable storage at the edge.

This skill helps you transform raw data into clean, production-ready analytical assets using dbt, pandas, polars, PySpark, and Airflow.

This skill helps you design and implement relational databases across languages, optimizing ORM, query builders, and migrations for reliable CRUD applications.

This skill designs scalable SQL and NoSQL schemas, applying normalization, indexing, migrations, and integrity rules to optimize performance.

This skill helps optimize Rails performance by detecting N+1 queries, indexing gaps, and memory issues to speed up responses.

This skill traces upstream data lineage by identifying sources, DAGs, and transformations to reveal data origins and feeding paths.

This skill analyzes downstream data impacts and identifies blast radius before changes, detailing affected tables, DAGs, dashboards, and owners.

This skill initializes and configures Astro Airflow projects with dependencies, connections, and project structure, accelerating setup and deployment.

This skill generates a comprehensive table profile, including metadata, statistics, quality assessment, and practical queries to understand structure, content,

This skill helps you write, validate, and troubleshoot osquery queries against platform schemas to improve accuracy and performance.

This skill helps you generate type-safe Go code from SQL queries with sqlc across SQLite, PostgreSQL, and MySQL.

This skill helps you design scalable, maintainable database structures by applying naming, indexing, and optimization guidelines across tables and queries.

This skill provides production-ready FastAPI project templates and patterns to accelerate starting new services and standardize architecture.

This skill guides you in creating robust dbt unit tests to validate model logic before production, ensuring reliability and preventing regressions.

This skill answers natural language business questions by querying dbt semantic layer, then explores models or manifests if needed to provide an accurate

This skill guides creating and modifying dbt semantic layer components, including models, entities, dimensions, and metrics, with validation and spec guidance.

This skill enables semantic search and SQL-like queries across your Obsidian vault, surfacing related notes and frontmatter metadata.

This skill helps you design multi-tenant database schemas, choose a suitable platform, and implement secure, scalable data patterns for SaaS.

This skill guides you through using PostgreSQL psql for interactive queries, scripts, connections, and administration to streamline database tasks.