supabase-database
Perform database operations (CRUD) on Supabase tables using the REST API. Use for querying, inserting, updating, and deleting data in your Supabase database.
Perform database operations (CRUD) on Supabase tables using the REST API. Use for querying, inserting, updating, and deleting data in your Supabase database.
Subscribe to realtime changes in Supabase using WebSocket connections. Use for listening to database changes, presence tracking, and broadcast messaging.
Post-hoc Oracle operations - consult the Oracle on existing VernHole output or apply an Oracle vision to rewrite VTS tasks.
Run the repo health gate before commit or push to reduce doc drift and keep branches clean. Triggers on commit, push, before push, repo health, reduce drift, doc drift, clean branch.
Podman changes since training cutoff (latest: 5.8.0) — Quadlet CLI management, OCI artifacts, multi-file install, BoltDB→SQLite migration, TLS remote. Load before working with Podman.
Database management with Drizzle ORM. Use when modifying schemas, running migrations, or working with database operations.
Authoring guideline for DuckPQ/DuckTable-based Parquet storage in Quool. Covers DuckPQ initialization, table discovery and registration, CRUD operations (upsert/select/load/query), cross-table JOIN queries using the <table><sep><column> pattern, DataFrame attachment, and parquet compaction. Encourages using DuckPQ as the top-level database interface rather than operating on DuckTable in isolation.
Introspects Supabase DB after migrations and updates project db-query skill with current schema. Run after any migration to keep agent context accurate.
Use when writing raw SQL queries with GRDB, complex joins, ValueObservation for reactive queries, DatabaseMigrator patterns, query profiling under performance pressure, or dropping down from SQLiteData for performance - direct SQLite access for iOS/macOS
Prisma changes since training cutoff (latest: 7.3) — v7 ESM rewrite, prisma-client generator, driver adapters, prisma.config.ts, TypedSQL, SQL comments. Load before working with Prisma.
Use when adding/modifying database columns, encountering "FOREIGN KEY constraint failed", "no such column", "cannot add NOT NULL column" errors, or creating schema migrations for SQLite/GRDB/SQLiteData - prevents data loss with safe migration patterns and testing workflows for iOS/macOS apps
First-run setup wizard for the memory system. Creates directory structure, config, and starter files. Use when: (1) First time using Miracle Infrastructure, (2) "Initialize memory", (3) Setting up on new machine. Triggers: "/memory-init", "initialize memory", "setup memory".
Use when working with caching in any Elixir project that uses the elixir_cache library. TRIGGER on any of these scenarios: (1) Adding, modifying, or debugging any cache module (`use Cache`, `_cache` suffix modules, adapter selection); (2) Choosing between adapters (ETS vs Redis vs ConCache vs PersistentTerm vs Counter vs DETS vs Agent); (3) Redis operations — hash_get/hash_set/hash_scan, json_get/json_set, sadd/smembers, scan, command, pipeline, connection pools; (4) ETS operations — update_counter, match_pattern, tab2file, rehydration, read_concurrency; (5) Strategy adapters — MultiLayer (L1/L2 caching), HashRing (distributed/consistent hashing), RefreshAhead (proactive refresh); (6) Testing caches — Cache.CaseTemplate, SandboxRegistry, sandbox?, async test isolation, cache mocking; (7) Cache patterns — get_or_create, cache invalidation, cache warming, TTL management, compression_level; (8) Infrastructure — supervision tree setup with {Cache, [modules]}, runtime config, Poolboy pools; (9) Performance — thund
Caching patterns for the elixir_cache project. TRIGGER when: writing or modifying caching code involving Redis, ETS, elixir_cache, Cachex, or any of the _cache apps. Also trigger when working with RedisLock, Cache.Redis, Cache.ETS, or cache sandbox testing. DO NOT TRIGGER when: working with code that doesn't involve caching layers.
Implement data persistence using SQLite with Dapper, JSON file storage, or event sourcing patterns. Use when adding database tables, CRUD operations, file storage, or event logs. Creates code in src/Server/Persistence.fs with patterns for queries, transactions, relationships, and async I/O. Includes SQLite schema creation, parameterized queries, and proper connection management.
SQLx changes since training cutoff (latest: 0.9.0-alpha.1) — SqlSafeStr, owned Arguments, sqlx.toml config, begin_with transactions, SQLite hooks, PgBindIter. Load before working with SQLx.
Expert knowledge for building SQL database sinks from Solana/SVM Substreams. Covers DatabaseChanges, ClickHouse schemas, PostgreSQL schemas, and materialized views for Solana DEX/token data.
Write type-safe, schema-safe SQL using the StructuredQueries library
Use the SQLiteData library to read and write to a SQLite database, observe queries (`@FetchAll`, `@FetchOne`, `@Fetch`), synchronize to iCloud (`SyncEngine`), and share records with other iCloud users.
PostgreSQL changes since training cutoff (latest: 18.1) — JSON_TABLE, SQL/JSON functions, MERGE RETURNING, virtual generated columns, UUIDv7, temporal PRIMARY KEY. Load before working with PostgreSQL.
PostGIS changes since training cutoff (latest: 3.6.1) — SFCGAL CG_* rename, ST_CoverageClean, ST_AsRasterAgg, topology bigint IDs, viewport simplification, 3D SFCGAL ops. Load before working with PostGIS.