Databases Agent Skills

Guides safe, reversible PostgreSQL schema and data migrations using golang-migrate, Prisma, Drizzle, or Django migrations.

Guides PostgreSQL query design, indexing strategy, data types, and row-level security patterns — the query/schema layer, as distinct from…

PostgreSQL database patterns for query optimization, schema design, indexing, and security.

Comprehensive Snowflake development assistant covering SQL best practices, data pipeline design (Dynamic Tables, Streams, Tasks…

Use when the user says 'draw', 'diagram', 'visualize', 'architecture', or needs a visual overview of code structure.

Use when preparing a SIGMOD paper's code and data for the Availability & Reproducibility Initiative (ARI), covering the post-acceptance…

Use when designing or auditing the evaluation of a SIGMOD paper, covering workload realism and standard benchmark usage, baseline tuning…

ACSets (Attributed C-Sets) for categorical database design and DPO rewriting

Record-level CRUD and bulk operations — create, update, delete, upsert, CSV import, multi-table foreign-key loads, AI-generated sample data.

Bulk reads, multi-page iteration, and analytics over Dataverse data.

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

Pre-ship model slim — find and remove UNUSED COLUMNS and orphan measures from a PBIP semantic model before publishing.

Execute comprehensive database smoke tests to validate connectivity, query performance, data integrity, and backup/restore operations…

MUST use when writing Snowflake queries.

Choose and implement Snowflake architecture blueprints: data lakehouse,

Execute Snowflake primary workflow: data loading via stages and COPY

Execute Snowflake data transformation with streams, tasks, and dynamic tables.

Collect Snowflake debug evidence for support tickets and troubleshooting.

Use when writing Snowflake SQL, building data pipelines with Dynamic Tables or Streams/Tasks, using Cortex AI functions, creating Cortex…

Configure Snowflake enterprise RBAC with system roles, custom role hierarchies,

Configure Snowflake local development with testing, mocking, and fast iteration.