Prisma

Connects to your Prisma-managed Postgres database and gives you a conversational interface to run migrations, inspect schemas, and execute SQL. You can ask Claude to generate a Prisma migration file from a schema diff, show the SQL it will run, and apply or rollback migrations. It also reads migration history and shows which migrations are applied vs pending.

Runs queries you type or ones Claude generates from natural language, returning rows or summaries. It can introspect the current DB schema, map tables to Prisma models, and produce model definitions you can copy into schema.prisma. It supports running queries inside transactions and offers dry-run SQL so you can review destructive changes before applying them.

Connects to cloud Postgres instances or local dev databases via your connection string. You can spin up ephemeral instances for testing, seed data, and then tear them down. It watches for schema drift and can suggest migration steps to reconcile Prisma models with the live database.

Works well when you're fixing a bug or adding a feature and want to avoid switching to a GUI: ask for the schema diff, get the migration SQL, review results, and apply it all from Claude while also running test queries — saves time compared to jumping between an ORM, psql, and a database GUI.