Databases Agent Skills

Transform Vertica DDL (views, tables, stored procedures) into production-quality dbt models compatible with Snowflake, maintaining the…

Use when designing or auditing the evaluation of a VLDB paper, covering workload and dataset realism at scale, competitor tuning fairness…

MUST use when writing MySQL queries.

Windows and Git Bash path handling for SSDT, SqlPackage, and DACPAC files.

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

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

Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL…

Designs Zod schemas following Zod-first development.

Exports 1C:Enterprise configurations to XML source files for version control and development analysis.

Creates and initializes 1C:Enterprise 8.3 information bases using automated command-line workflows.

Manages 1C:Enterprise database registries and connection parameters for streamlined development workflows.

Automates the application of configuration changes to 1C:Enterprise 8.3 databases using the UpdateDBCfg command.

Analyzes and summarizes 1C:Enterprise Data Composition System (SKD) schemas to simplify report development and debugging.

Use Redis effectively for caching, pub/sub messaging, rate limiting, distributed locks, and session storage.

Analyzes complex SQL queries to improve performance, suggesting indexing strategies, schema refactoring, and query rewrites.

Aarondb

Taxonomy of ACSet skills with morphisms to semantically similar categorical/relational skills

Define database models with clear naming, appropriate data types, constraints, relationships, and validation at multiple layers.

Comprehensive guide for migrating PostgreSQL tables to TimescaleDB hypertables with optimal configuration and performance validation

Use when adding a new scenario to remindb's benchmark suite — symptoms include "compare X tool against grep/cat", "add a token-savings…

Use when adding a new file format to remindb's parser package — symptoms include "support .toml/.csv/.xml files", "ingest a new file…