Database Workflows with MCP
PostgreSQL, Supabase, Prisma Integration
Master database workflows with Claude as your AI database engineer. Query PostgreSQL, generate migrations with Prisma, manage schema changes, and leverage Supabase's real-time capabilities—all through conversational commands.
Prerequisites
- • PostgreSQL database (local, AWS RDS, or Supabase)
- • Prisma ORM installed in your project
- • Supabase account for cloud-managed PostgreSQL (optional)
- • CuratedMCP account and Claude Desktop configured
Building Your Database Workflow
Set up PostgreSQL MCP server
Connect Claude directly to your PostgreSQL database for safe, read-write query execution.
- Create a PostgreSQL user with limited permissions (avoid root/superuser)
- Add connection details to CuratedMCP's PostgreSQL MCP server configuration
- Enable query validation to prevent destructive operations without confirmation
Configure Prisma integration
Use Prisma ORM to manage schema changes and migrations through Claude.
- Set up Prisma with your PostgreSQL database connection string
- Generate Prisma client types for type-safe query building
- Add Prisma CLI to your MCP server configuration for migrations and introspection
Connect Supabase for real-time features
Leverage Supabase's real-time subscriptions and managed PostgreSQL.
- Generate a Supabase API key from your project settings
- Configure the Supabase MCP server with your project URL and API key
- Enable real-time listeners for table changes and database events
Generate unified database configuration
Combine all three services into a single CuratedMCP stack.
- Visit /marketplace and select PostgreSQL, Prisma, and Supabase servers
- Review the auto-generated configuration for safety and completeness
- Export and integrate into your Claude Desktop or IDE configuration
Test database queries
Verify Claude can safely execute queries, migrations, and schema changes.
- Ask Claude: 'Show me the schema for the users table'
- Ask: 'Generate a migration to add an email_verified column'
- Ask: 'Find users who haven't logged in in 30 days'
Automate data workflows
Build end-to-end workflows: backups, data imports, migrations, analytics.
- Claude can generate migration files, validate them, and explain changes
- Use Prisma migrations for version control of schema changes
- Leverage Supabase for real-time notifications when workflows complete
Real-World Use Cases
Schema Migrations
Ask Claude to generate a migration script. It creates the SQL, validates it, and explains the impact. Review, approve, and run with a single command.
Data Analysis & Reporting
Ask Claude to query complex data patterns, then generate summary reports or dashboards. Use Supabase's real-time features to auto-update dashboards.
Bulk Data Operations
Import CSV data, transform it with Prisma, and bulk insert into PostgreSQL. Claude can validate data quality and generate transformation logic.
Backup & Restoration
Claude can orchestrate backups of critical tables, validate backups, and restore data when needed. Supabase handles point-in-time recovery.
Performance Optimization
Analyze query logs, identify slow queries, and suggest index creation. Claude reviews the suggestions and generates Prisma migration files.
Configuration Examples
PostgreSQL Server
Configure your PostgreSQL connection with limited permissions:
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": ["postgres-mcp-server"],
"env": {
"DATABASE_URL": "postgresql://user:password@localhost:5432/mydb",
"QUERY_MODE": "read-write",
"ALLOW_MIGRATIONS": "true"
}
}
}
}Prisma Integration
Prisma CLI integrated via MCP for migrations and schema introspection:
# Your prisma/schema.prisma
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
}
model User {
id Int @id @default(autoincrement())
email String @unique
name String?
createdAt DateTime @default(now())
}
# MCP exposes:
# - prisma migrate create --name <migration_name>
# - prisma migrate dev
# - prisma db seed
# - prisma studio (view data)Supabase Real-time
Enable real-time subscriptions to table changes:
{
"mcpServers": {
"supabase": {
"command": "npx",
"args": ["supabase-mcp-server"],
"env": {
"SUPABASE_URL": "https://your-project.supabase.co",
"SUPABASE_API_KEY": "your-anon-key",
"REALTIME_ENABLED": "true"
}
}
}
}Sample Claude Queries
"Generate a migration to add a phone_number field to users"
Claude creates a Prisma migration, previews the SQL, and explains the change.
"Find users who created accounts in the last 7 days"
Claude queries PostgreSQL and returns results with aggregated statistics.
"Create an index on the email column and show me the impact"
Claude generates the migration, estimates query performance improvement, and applies it.
"Export the last month of user activity to CSV"
Claude queries data, formats it, and generates a downloadable CSV file.
Best Practices
Limit User Permissions
Create a PostgreSQL user with minimal permissions. Avoid giving read-write access to sensitive schemas. Use Supabase Row Level Security (RLS) for additional protection.
Always Review Migrations
Before applying migrations to production, review the generated SQL and test in a staging environment. Use Prisma's preview feature to validate changes.
Backup Before Large Operations
Create backups before bulk updates or deletions. Supabase provides automated backups and point-in-time recovery.
Next Steps
- Set up PostgreSQL with a limited user account
- Install and configure Prisma in your project
- Browse CuratedMCP marketplace for PostgreSQL, Prisma, and Supabase servers
- Generate your database configuration stack
- Test with simple queries before running migrations
- Build a production workflow for data imports and backups
Ready to Automate Your Database?
Explore Database MCP ServersQuestions? See our setup guide.