Databases Agent Skills

PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement.

Make the arbitrary decisions in a schema explicit — what makes two records the same thing, whether a row is one thing or several, when a…

Optimize AgentDB performance with quantization (4-32x memory reduction), HNSW indexing (150x faster search), caching, and batch operations.

Build EVM blockchain data indexers using Ponder (ponder.sh) - an open-source TypeScript framework for indexing smart contract events…

This skill should be used when writing PostGIS queries, using spatial functions, geography types, raster operations, topology, or any…

Postgres and Supabase. Use when writing SQL, migrations, row level security, or indexes, and when diagnosing a slow query.

This skill should be used when the user asks to "write a query for a hotel-partitioned table", "review this SQL for partition safety"…

PostgreSQL indexing strategies and optimization

PostgreSQL database patterns for query optimization, schema design, indexing, and security.

Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features.

Execute read-only SQL queries against multiple PostgreSQL databases.

Prisma ORM: schema design, relations, migrations, nested writes, middleware, raw queries, type-safe database access

You are an expert in Prisma ORM with deep knowledge of schema design, migrations, query optimization, relations modeling, and database…

Prisma ORM patterns for TypeScript backends — schema design, query optimization, transactions, pagination, and critical traps like…

Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.).

Prisma Client query patterns

Prisma relation modeling patterns

Prisma schema design patterns

Required reference for Prisma ORM 7 SQL driver adapter work.

Build read models and projections from event streams.

Use when writing, editing, reviewing, or debugging q/kdb+ code (.q files), querying kdb+ tables, translating Python to q, running q from…