encore-database
Database queries, migrations, and ORM integration with Encore.ts.
Database queries, migrations, and ORM integration with Encore.ts.
Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.
Use when creating, updating, reviewing, or merging a PR in this repo. Covers first-push rebases, review and simplification passes, benchmark baseline requirements, and post-merge `$postmortem` runs.
Development patterns with MySQL/MariaDB via FireDAC — connection, stored procedures, AUTO_INCREMENT, JSON, triggers, replication, migrations
Development patterns with MySQL/MariaDB via FireDAC — connection, stored procedures, AUTO_INCREMENT, JSON, triggers, replication, migrations
Testcontainers NoSQL 整合測試完整指南。當需要對 MongoDB 或 Redis 進行容器化整合測試時使用。涵蓋 MongoDB 文件操作、Redis 五種資料結構、Collection Fixture 模式。包含 BSON 序列化、索引效能測試、資料隔離策略與容器生命週期管理。 Make sure to use this skill whenever the user mentions Testcontainers MongoDB, Testcontainers Redis, NoSQL integration test, BSON serialization, or Redis data structure testing, even if they don't explicitly ask for NoSQL container testing. Keywords: testcontainers mongodb, testcontainers redis, mongodb integration test, redis integration test, nosql testing, MongoDbContainer, RedisContainer, IMongoDatabase, IConnectionMultiplexer, BSON serialization, BsonDocument, 文件模型測試, 快取測試, Collection Fixture
PostgreSQL database patterns for query optimization, schema design, indexing, and security. Based on Supabase best practices.
[production-grade internal] Designs and optimizes database systems — schema design, query optimization, migration management, indexing strategy, scaling patterns, and multi-database architecture. Routed via the production-grade orchestrator.
Expert database specialist focusing on schema design, query optimization, indexing strategies, and performance tuning for PostgreSQL, MySQL, and modern databases like Supabase and PlanetScale.
Development patterns with PostgreSQL via FireDAC — connection, PL/pgSQL, sequences, JSONB, UPSERT, full-text search, migrations
Development patterns with PostgreSQL via FireDAC — connection, PL/pgSQL, sequences, JSONB, UPSERT, full-text search, migrations
Use for bun:sqlite, SQLite operations, prepared statements, transactions, and queries.
Verify a PR is ready, merge it, deploy frontend to Vercel and database to Supabase, and confirm health. Use when the Deploy Agent needs to ship code to production.
Core client for the Sp00ky reactive local-first SurrealDB framework. Use when initializing Sp00kyClient, registering queries and subscriptions, performing mutations (create/update/delete), handling auth (signUp/signIn/signOut), working with file buckets, or using backend runs (HTTP outbox pattern).
Software Mansion's best practices for multithreading and background processing in React Native apps. Use when offloading heavy computation, running background tasks, using Web Workers, or working with the React Native New Architecture's concurrent features. Trigger on: 'background thread', 'Worklet', 'runOnJS', 'runOnUI', 'heavy computation', 'background processing', 'concurrent', or any request to move work off the JS thread in a React Native app.
Manage database schemas, Drizzle ORM, migrations, and data modeling.
v1からv2へのAI-DLC環境移行を実行するスキル。 プリフライト検証、データ移行、移行後検証を行う。 Use when the user says "start migrate", "aidlc migrate", "マイグレーション".
Implements fast O(1) lookup patterns using HashSet, FrozenSet, and optimized Dictionary in .NET. Use when building high-performance search or membership testing operations.
This skill should be used when designing database schemas for SQL or NoSQL databases. It provides normalization guidelines, indexing strategies, migration patterns, and performance optimization.
Masters modern SQL across PostgreSQL, BigQuery, Snowflake, and hybrid OLTP/OLAP systems — covering advanced query techniques, dimensional modeling, time-series SQL, and data warehouse patterns. Use when writing complex analytics SQL, designing cloud database schemas, or optimizing cross-platform SQL workloads.
Transforms slow PostgreSQL queries into fast operations through systematic EXPLAIN ANALYZE, indexing strategies, N+1 elimination, cursor pagination, and materialized views. Use when diagnosing slow queries, optimizing database performance, or designing index strategies — always profile before optimizing.
Supabase PostgreSQL best practices library — 33 impact-rated rules (CRITICAL→LOW) covering connection pooling, RLS, locking, VACUUM, full-text search, and JSONB indexing. Use when writing, reviewing, or optimizing PostgreSQL queries, schema, or configuration.
PostgreSQL-specific schema design reference for advanced data types (ENUM, array, range, network, domain), storage internals (MVCC, HOT updates, TOAST, heap), and advanced constraints (EXCLUDE, generated columns). Use when designing PostgreSQL schemas, choosing data types, working with extensions (pgvector, PostGIS, TimescaleDB), or handling schema evolution safely without downtime.