Skip to main content
MCP server CX Codex

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 GitHub

What 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.

Similar MCP servers

All MCP servers for Data and databases →

Project sponsors

Companies that keep this analytics open