DreamFactory MCP

Name: DreamFactory MCP
Author: DreamFactory

by DreamFactory

Securely query MS SQL, MySQL, PostgreSQL and more through RBAC-controlled REST APIs

database Node.js Intermediate Self-hostable

⭐ 100 stars 📅 Updated: 1mo ago

View on GitHub View package

Description

MCP server for DreamFactory, a platform that automatically generates secure REST APIs from any database. Instead of connecting directly to databases, this server routes all queries through DreamFactory's RBAC (Role-Based Access Control) layer, ensuring that AI assistants only access data they are authorized to see. Supports MS SQL Server, MySQL, PostgreSQL, Oracle, MongoDB, and many other database backends through a unified API interface. DreamFactory handles authentication, rate limiting, and audit logging — so you get enterprise-grade security without building custom middleware. Ideal for teams that need to give AI access to production databases without exposing raw connection strings.

✅ Best for

Enterprise teams that need to give AI assistants secure, audited access to multiple databases without exposing raw credentials

⏭️ Skip if

You have a single database and are comfortable with direct SQL connections

💡 Use cases

Querying multiple database backends through a single secure API layer
Giving AI assistants controlled access to production data with RBAC
Exploring and managing records across different database types from one interface
Building data pipelines that respect role-based permissions automatically

👍 Pros

✓ RBAC-controlled access — AI only sees what its role allows, not raw database access
✓ Multi-database support (SQL Server, MySQL, PostgreSQL, Oracle, MongoDB) via unified API
✓ No raw database credentials exposed to the AI assistant
✓ DreamFactory handles authentication, rate limiting, and audit logging out of the box

👎 Cons

✗ Requires a running DreamFactory instance as middleware between AI and databases
✗ Additional latency from routing queries through the API layer
✗ DreamFactory itself needs configuration and maintenance

🔧 Exposed tools (5 tools)

Tool	Category	Description
list_tables	discovery	List all tables available in a database service
describe_schema	discovery	Get the schema definition and column details for a table
list_services	discovery	List all database services configured in DreamFactory
query_database	query	Execute a query against a database through the DreamFactory API
manage_records	write	Create, update, or delete records in a table

⚡ Installation

Prerequisites:

• Node.js v18+
• DreamFactory API key and instance URL
• API key required

Check Claude Code documentation to configure this MCP server.

💡 Tips & tricks

Set up your DreamFactory instance first and configure database connections through its admin panel. Use list_services to see all available database backends, then list_tables to explore each one. The RBAC layer means you should configure an appropriate API role for the AI assistant — avoid using admin-level API keys.

🔄 Alternatives

mysql-mcp

MCP server — editorial content pending

Similar functionality

postgresql-mcp