By name: storage-and-query-engines description: Databases and query engines — storage layouts, SQL parse→plan→execute, transactions, indexing, every database kind.
storage and query engines
Category skill (blueprint pack). The description above is the only thing the
router sees — broad and generic on purpose. The fat detail lives in the
blueprints below; open the one that matches and read it in full.
Governs its own form per .claude/rules/rules-are-small-carved-sentences-pointing-to-docs.md
and .claude/rules/mirror-beacon-register-discipline.md (carved sentence = hub /
Beacon; blueprint = satellite / Mirror). The directory is an independent shipping unit.
Blueprints
postgresql-expert— PostgreSQL — wire protocol, type system, system catalogs, dialect extensions, EXPLAIN, pg_hba auth.relational-database-expert— RDBMS family — Postgres/MySQL/MSSQL/Oracle/SQLite/NewSQL, Codd forms, MVCC vs 2PL, WAL, partitioning.document-database-expert— Document databases — MongoDB, Cosmos DB, Firestore, CouchDB; schema design, aggregation, sharding, embed/reference.graph-database-expert— "Graph databases — Neo4j, Neptune, JanusGraph, Memgraph; Cypher/GQL/Gremlin, RDF, supernodes, traversals."vector-database-expert— "Vector databases — Milvus, Weaviate, Qdrant, pgvector, Pinecone; HNSW/IVF-PQ, ANN benchmarks, hybrid search, embeddings."wide-column-database-expert— "Wide-column databases — Cassandra, HBase, Bigtable; row keys, sparse columns, SSTables, quorum reads/writes, CQL."key-value-store-expert— "Key-value stores — Redis/Valkey, DynamoDB, etcd/ZooKeeper, FoundationDB, RocksDB/LMDB, eviction, caching."time-series-database-expert— Time-series databases — InfluxDB, TimescaleDB, QuestDB, IoTDB; downsampling, retention, continuous aggregates.columnar-storage-expert— "Columnar storage — segment layout, dictionary/RLE/FOR compression, Arrow/Parquet interop, late materialisation."row-store-expert— Row-store / OLTP layout — heap files, slotted pages, HOT chains, B+ tree leaves, FSM, latching, WAL images.catalog-expert— "SQL catalog — system tables, DDL semantics, schema evolution, OIDs, pg_* synthesis, concurrent DDL consistency."storage-specialist— Zeta.Core storage reviewer — DiskBackingStore, Spine family, checkpoint format, durability modes, WDC advisory.file-system-persistence-expert— File-system durability — fsync/fdatasync, journal semantics, io_uring/IOCP, atomic rename, crash-safety, path hazards.transaction-manager-expert— SQL transaction manager — ACID, isolation, MVCC, 2PL, deadlocks, savepoints, 2PC/Saga, commit protocols.concurrency-control-expert— "Concurrency control — conflict detection, read-write sets, SSI, deadlock prevention, abort policies, lock manager."sql-engine-expert— Zeta SQL engine umbrella — parser, binder, optimizer, planner, execution model, storage, wire protocol.sql-expert— SQL standard — SQL:2016/2023, three-valued logic, grouping/window/CTE, isolation levels, dialect drift across engines.sql-parser-expert— SQL parser — lexing, grammar choice (libpg_query/ANTLR4/recursive-descent), AST design, error recovery, fuzzing.sql-binder-expert— SQL binder — name resolution, type coercion, overload resolution, scope rules, ambiguity before optimization.query-optimizer-expert— Query optimizer — cost model, cardinality estimation, logical rewrite rules, join-order enumeration, statistics.query-planner— Query planner review — join ordering, predicate pushdown, indexes, SIMD dispatch, cardinality estimates, cost model.distributed-query-execution-expert— Distributed SQL execution — partitioning, shuffle/broadcast/gather, collocated joins, aggregation, shard routing.database-systems-expert— Database systems — storage models, CAP/PACELC, consistency, NewSQL, sharding, polyglot persistence, anomalies.entity-framework-expert— EF Core — provider model, LINQ→SQL translation, DbContext lifecycle, change tracking, migrations, Zeta provider design.