Sql skills

This skill validates and analyzes JSON SQL primitives using semantic-scholar output to ensure accurate data extraction, filtering, and sorting.

This skill helps you design and manage ClickHouse materialized views for real-time aggregation and data transformation, optimizing queries and avoiding common

This skill helps you design ClickHouse schemas with optimized ORDER BY, partitioning, and data types to achieve sub-second queries and strong compression.

This skill extracts specified nested metadata from each note in a collection, returning only the requested fields for structured downstream use.

This skill analyzes internal test data, applies a where citations > 100 filter, and returns the high-cited items.

This skill automates Supabase development workflows with CLI tooling for migrations, edge functions, secrets, and type generation, boosting safety and speed.

This skill tests and explains SQL sort by implementing descending order on a papers collection and validating output.

This skill designs robust database schemas, generates safe migrations, and documents ER diagrams to ensure data integrity and scalable queries.

This skill helps you build type-safe SQL queries and migrations with Drizzle ORM for TypeScript in Next.js or Node.js apps.

This skill helps persist AI chat conversations in Neon Postgres, including AI SDK message parts, tools, reasoning, and streaming for reliable history.

This skill helps you write and optimize SQL queries using common patterns, CTEs, and window functions for faster data retrieval.

This skill guides you through designing scalable SQL and NoSQL schemas, optimizing normalization, indexing, migrations, and performance for maintainable data

This skill helps you implement robust Python database patterns with SQLAlchemy 2.0, AsyncIO support, and repository patterns for reliable data access.

This skill helps you write type-safe Drizzle ORM queries in TypeScript for select, insert, update, delete, and relational data.

This skill streamlines SQLite usage in Python projects by guiding connection handling, WAL mode, and simple migration patterns for reliable local data.

This skill enforces data integrity between TypeScript and PostgreSQL by applying zero-trust, migration-safe patterns with Prisma 7 and PostgreSQL 18.

This skill helps design safe database migrations with zero-downtime, rollback-safe plans and thorough testing across PostgreSQL, MySQL, and other supported

This skill helps you design and optimize scalable data pipelines, warehouses, and analytics infrastructure across batch, streaming, and ELT workflows.

This skill documents and tests dbt projects with YAML conventions, sources, macros, and CI patterns to guide when designing, validating, and auditing models.

This skill generates optimized queries, caching, and indexes to boost Frappe performance and eliminate slow queries.

This skill helps you configure mirrord.json for safe database branching, generating valid configs and explaining copy modes, IAM auth, and branch management.