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…
Use when adding or modifying a SQL query against the SQLite store — symptoms include "add a method to *Store", "new column on nodes"…
Use when creating a new database table, entity, or data model.