Prisma Postgres — Claude Code MCP Server
Prisma Postgres connects your AI assistant to PostgreSQL databases via Prisma ORM for safe queries and schema migrations. Helps inspect and update relational data directly from the editor.
no license updated 2026-10-29
Open on GitHubWhat Prisma Postgres does
The server links your coding environment to PostgreSQL databases using Prisma ORM. Instead of executing raw database scripts, the model works with typed queries and applies automated schema migrations. Type safety prevents malformed structures during updates.
Compatibility covers Claude Code, Codex, Cursor, and Zed among other MCP clients. Working with the server requires an accessible PostgreSQL instance alongside a configured Prisma setup.
Docker provides this integration. It suits workflows where an agent inspects database tables or writes migrations directly in the IDE.
What it helps with
- run type-safe queries against PostgreSQL using Prisma
- apply automated database schema migrations
- inspect relational database schemas from the assistant prompt
- generate database operations without manual SQL authoring
Example prompts for the agent
- Run the Prisma migration to add a new profile table to PostgreSQL.
- Query all active accounts from the PostgreSQL database using Prisma.
- Inspect the PostgreSQL schema and generate the corresponding Prisma model.
How to install Prisma Postgres
Install
The MCP registry has no launch command for it: see the repository README
Step by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about Prisma Postgres
What does the Prisma Postgres MCP server do?
It lets coding assistants interact with PostgreSQL through Prisma ORM to execute typed queries and run schema migrations.
Which platforms support Prisma Postgres?
It supports Claude Code, Codex, Cursor, GitHub Copilot, Windsurf, Cline, Zed, and Gemini CLI.
What prerequisites are needed for Prisma Postgres?
You need an accessible PostgreSQL database instance and a project with Prisma configured.