database-orm
Interaction with NeonDB Postgres using Drizzle ORM.
Interaction with NeonDB Postgres using Drizzle ORM.
Write safe PostgreSQL migrations that avoid blocking reads/writes. Use when creating migrations, adding columns, indexes, constraints, or modifying tables. Based on Squawk linter rules.
Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
Generate database schema from feature descriptions. User doesn't see SQL. Use when: features require data persistence. Triggers: internal use only.
Core Neo4j schema reference with all labels, relationships, data types, and indexes. Use when exploring database structure, checking field types, or understanding the financial knowledge graph schema.
CRITICAL: PostgreSQL MCP Server SQL limitations and correct patterns. This skill MUST be consulted before writing any SQL for the CRM database. Documents what works and what DOES NOT work with mcp__postgresql__ tools.
Designs comprehensive database schemas including relational and NoSQL models, normalization, indexing strategies, relationship modeling, data types, constraints, and performance optimization. Covers entity-relationship diagrams, schema migrations, partitioning, and best practices for PostgreSQL, MySQL, MongoDB, and other databases. Use when designing databases, creating schemas, modeling data, optimizing queries, or when users mention "database design", "schema design", "data modeling", "ERD", "normalization", "indexing", or "database architecture".
Step-by-step guide for modifying database schema using Diesel migrations
DBマイグレーション支援。スキーマ変更やマイグレーション作成依頼時に使用。ORM自動検出、命名規則確認、既存マイグレーションとの整合性を検証。
Database operations: migrations, queries, transactions, and performance. Use when: - Writing database migrations - Optimizing queries or adding indexes - Managing transactions and connections - Setting up connection pooling - Designing audit logging Keywords: database, migration, SQL, query optimization, index, transaction, connection pool, N+1, ORM, audit log
Patterns for using Peewee ORM with DatabaseProxy and scoped connections/transactions. Use when setting up DatabaseProxy, managing connection_context/atomic blocks, or writing tests with SQLite.
ActiveRecord model patterns and conventions for Rails. Automatically invoked when working with models, associations, validations, scopes, callbacks, or database schema design. Triggers on "model", "ActiveRecord", "association", "has_many", "belongs_to", "validation", "validates", "scope", "callback", "migration", "schema", "index", "foreign key".
Database design, Query optimization, and Data integrity expert for SQL and NoSQL.
Rossum Data Storage API reference — MongoDB-compatible REST API for collections, CRUD operations, find, aggregate, bulk_write, indexes, and Atlas Search indexes. Use when querying or managing data in Rossum's Data Storage service directly via API.
MongoDB query language reference tailored for Rossum. Covers find operators, regex patterns, aggregation pipeline stages, expression operators, Atlas Search ($search with fuzzy, compound, dynamic thresholds, embedded documents), $function, $lookup, $unionWith, practical matching patterns, data type handling, performance tips, and debugging. Use when writing or debugging MongoDB queries in any Rossum context (MDH matching, Data Storage, aggregation pipelines).
MongoDB with Kotlin coroutine driver. Use when adding MongoDB collections, writing queries, creating BSON mappings, implementing save with optimistic locking, building indexes, wiring collections into features, or setting up TestContainers.
Designs Redis usage for caching, rate limiting, and distributed locks.
Use when working with objects in Tigris Storage - uploading, downloading, deleting, listing, getting metadata, or generating presigned URLs
Use swiftfindrefs (IndexStoreDB) to list every Swift source.
Azure Cosmos DB incident response agent. Quickly identify and diagnose issues in Cosmos DB accounts including throughput, latency, partitioning, and availability.
Implement Redis caching and pub/sub using the Storm.Api framework with IRedisService for key-value storage, TTL, and channel subscriptions.
Use when needing to query databases across environments (local, QA, UAT, prod) for investigation, debugging, or data verification. Triggers on "check the database", "query eventstore", "subscription lag", "look at UAT", "check QA database", "oban jobs", "read model state", or any database investigation request.