Parses, edits, and generates A5:SQL Mk-2 ER diagram (.a5er) files safely while maintaining formatting integrity and reference consistency.
Master advanced AgentDB features including QUIC synchronization, multi-database management, custom distance metrics, hybrid search, and…
Optimize AgentDB performance with quantization (4-32x memory reduction), HNSW indexing (150x faster search), caching, and batch operations.
Database schema design, migrations, query optimization with SQL, Exposed ORM, Flyway.
Comprehensive guide for migrating PostgreSQL tables to TimescaleDB hypertables with optimal configuration and performance validation
Use this skill when a read model genuinely needs an IReducerFor<T> — when model-bound projection attributes and fluent IProjectionFor<T>…
JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in…
JetBrains Exposed ORM patterns including DSL queries, DAO pattern, transactions, HikariCP connection pooling, Flyway migrations, and…
Redis data structure patterns, caching strategies, distributed locks, rate limiting, pub/sub, and connection management for production…
Airtable API integration with managed OAuth.
Implement database sharding for horizontal scalability.
Implement event sourcing and CQRS patterns using event stores, aggregates, and projections.
Analyze and optimize SQL queries for performance.
Use this skill whenever a user wants to execute operations against Algolia indices or accounts — deleting records, copying/migrating…
Implement Algolia data handling: record transforms, PII filtering before
Use when the user asks to create ERD diagrams, normalize database schemas, design table relationships, or plan schema migrations.
Use when the user asks to write SQL queries, optimize database performance, generate migrations, explore database schemas, or work with…
Used to analyze Apache ShardingSphere community issues. Emphasizes root-cause-first and evidence-first classification before conclusions, and produces copy-ready GitHub issue replies in the voice of an Apache ShardingSphere community maintainer.
This skill uses the database-index-advisor plugin to analyze query patterns and recommend optimal database indexes.
Manages the reviewable patch lifecycle (validate -> dry-run -> apply) for canonical entities safely without directly mutating derived files.
Edit features with the Editor component/widget, configure forms, manage subtypes, handle attachments, and work with branch versioning.