Provides AI agents access to Prisma schemas, migration planning, and database introspection capabilities. Agents can propose migrations, explore data models, and generate type-safe queries based on your Prisma setup. Works with local projects and remote Prisma Data Proxy deployments.
Use cases
- Developer explores database schema to understand entity relationships
- Architect drafts migration plans for adding new features to data model
- TypeScript developer generates type definitions from Prisma schema
- DBA reviews generated SQL before applying migrations to production
- New team member understands codebase by querying data model structure
Key features
- Claude Desktop
- Claude Code
- Cursor
- VS Code
- Windsurf
Frequently Asked Questions
- What databases does Prisma MCP support?
- PostgreSQL, MySQL, SQLite, SQL Server, MongoDB, and CockroachDB are supported. Each requires the appropriate Prisma data source configuration.
- Can agents run migrations?
- Agents can generate migration plans and SQL. Actual migration execution requires user confirmation for safety. Use --dry-run to preview changes first.
- Does it work with Prisma Data Proxy for connection pooling?
- Yes, the MCP can connect through Prisma Data Proxy for managed connection pooling. Configure the DATA_PROXY_URL environment variable.
Related
Related
3 Indexed items
Supabase MCP
Connects agents to Supabase projects for table inspection, Edge Function debugging, database triggers, and real-time subscriptions. Agents can inspect RLS policies, view logs, and manage database types without the Supabase dashboard. Supports both hosted and self-hosted Supabase instances.
DuckDB MCP community extension (`duckdb_mcp`)
The DuckDB-distributed community extension `duckdb_mcp` embeds MCP client and server capabilities directly inside DuckDB. Installers load it via `INSTALL duckdb_mcp FROM community` followed by `LOAD duckdb_mcp`, after which SQL can attach remote MCP servers (stdio/TCP/WebSocket transports), enumerate resources (`mcp_list_resources`), invoke remote tools (`mcp_call_tool`), and wrap responses with `read_csv`/`read_json`/`read_parquet` URIs routed through `mcp://`. In reverse direction, DuckDB can publish tables, queries, and execution-bound tools (`mcp_publish_table`, `mcp_publish_query`, `mcp_publish_execution_tool`) while `mcp_server_start` exposes them to external MCP-compatible clients.
SQLite MCP
Provides lightweight SQL access to local SQLite database files for quick analytics, schema inspection, and prototyping without database server overhead. Agents can query, analyze, and generate reports from embedded datasets. Ideal for app sandboxes, development databases, and data exploration.