Databases Agent Skills for HTTP / API

Engineers source-grounded concepts and definitions, including definition, revision, audit, comparison, mapping, formalization…

Star schema, snowflake schema, SCD types, and Kimball methodology for analytical data modeling.

Discovering metadata on a running kdb+ process via `aimeta` — cold-start probing, the `/meta` HTTP route, `kx-meta discover`, qIPC…

Django migration patterns and safety workflow for PostHog.

Django performance code review. Use when asked to "review Django performance", "find N+1 queries", "optimize Django", "check queryset…

Creates and maintains dlt (data load tool) pipelines from APIs, databases, and other sources.

Follow these steps to install and configure the drs CLI for Dremio Cloud.

Manages database schemas and automates migrations using Drizzle ORM to ensure data consistency and type-safe development.

Dual-write pattern for safe data store transitions.

Dump clean Postgres schema to a file and copy path to clipboard.

Connects to the Baselight MCP (Model Context Protocol)

When to activate: DynamoDB, single table design, GSI, LSI, DynamoDB streams, DAX, capacity, AWS NoSQL

Prevent N+1 queries by eager loading; enable lazy-loading protection in non-production; choose selective fields

Create and apply EF Core migrations in Spiderly projects.

Use when writing Eloquent models, relationships, scopes, or queries via Model:: — 'fetch users with their orders'.

Define clear relationships and load data efficiently; prevent N+1, use constraints, counts/sums, and pivot syncing safely

Cache data in Redis from Encore.ts using `CacheCluster` and typed keyspaces from `encore.dev/storage/cache`.

Work with PostgreSQL in Encore.ts using `SQLDatabase` from `encore.dev/storage/sqldb` — schema migrations and SQL queries.

Work with PostgreSQL in Encore Go using `sqldb.NewDatabase` from `encore.dev/storage/sqldb` — schema migrations and SQL queries.

Trigger: loops, DB queries, rendering, or batch ops.

Automate Neon serverless Postgres operations -- manage projects, branches, databases, roles, and connection URIs via the Composio MCP…