Databases Agent Skills for Windsurf (legacy)

\"Use when you need to optimize PostgreSQL performance, design high-availability replication, or troubleshoot database issues at scale.

PostgreSQL query optimization, indexing, full-text search, JSONB, and advanced features.

MANDATORY when designing schemas, writing migrations, creating indexes, or making architectural database decisions - enforces PostgreSQL…

Advanced PostgreSQL patterns for performance optimization, complex queries, indexing strategies, and database design

Write or review PostgreSQL schemas, queries, migrations, and Drizzle ORM code.

Reviews PostgreSQL code for indexing strategies, JSONB operations, connection pooling, and transaction safety.

PostgreSQL operations, optimization, and administration.

PostgreSQL performance tuning and optimization

Administer and query PostgreSQL with psql

Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

Develops and manages Power BI Semantic Models.

Prisma 6.2–7.3 features: v7 migration (new generator, driver adapters required, prisma.config.ts), ULID support, updateManyAndReturn…

Automate Prisma tasks via Rube MCP (Composio).

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

Automates database table creation, Prisma migrations, and repository layer generation for robust backend architectures.

Prisma migration workflow patterns

Edit the Prisma Next data contract — add models, fields, relations, indexes, enums, value objects (composite types), type aliases…

Set up a new Prisma Postgres database and connect it to a local project using the Management API.

Prisma ORM CLI commands reference covering init, generate, migrate, db, dev, complete, studio, validate, format, debug, and mcp.

Prisma Client API reference covering model queries, filters, operators, and client methods.

Prisma Postgres setup and operations guidance across Console, create-db CLI, Management API, and Management API SDK.