# postgres-pro - PostgreSQL & Database Pro

> PostgreSQL database specialist for Cursor providing query optimization, index tuning, Drizzle/Prisma migrations, and connection pooling.

Canonical: https://www.agentickit.co/agents/postgres-pro
Last updated: 2026-11-18

The postgres-pro agent analyzes slow database queries, designs normalized relational schemas, crafts safe migration scripts, and configures pgvector embeddings for AI features. It protects production databases against locking and N+1 query patterns.

## Capabilities
- Drizzle ORM & Prisma schema generation and type safety
- EXPLAIN ANALYZE query plan diagnostics and composite indexing
- Safe zero-downtime database migrations with rollback plans
- Vector indexing using pgvector (IVFFlat & HNSW)

## Best for
- Optimizing complex SQL queries and slow database transactions
- Writing reliable schema migrations in Drizzle or Prisma
- Setting up Row Level Security (RLS) in Supabase or PostgreSQL

**Claude Code grant:** `tools: Read, Write, Edit, Glob, Grep, Skill, Bash, TodoWrite` · `model: inherit`

## Related
- [postgres-drizzle](https://www.agentickit.co/skills/postgres-drizzle)
- [saas-patterns](https://www.agentickit.co/skills/saas-patterns)
- [vector-database](https://www.agentickit.co/skills/vector-database)
- [error-handling](https://www.agentickit.co/skills/error-handling)
- [/build-api](https://www.agentickit.co/commands/build-api)
- [/audit](https://www.agentickit.co/commands/audit)
- [/ai-feature](https://www.agentickit.co/commands/ai-feature)
