# DreamFactory

Connects coding assistants to databases through the DreamFactory gateway. It lets agents interact with enterprise data via governed REST endpoints.

- MCP server · `type=mcp` · Claude Code, Codex, Cursor, GitHub Copilot, Windsurf (Devin Desktop), Cline, Zed, Gemini CLI
- Author: dreamfactorysoftware
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/dreamfactorysoftware/df-mcp
- Updated: 2026-10-29
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/mcp/dreamfactory

## What it does

This server translates MCP protocol requests into DreamFactory REST calls. It allows the model to query sources like PostgreSQL, MySQL, Microsoft SQL Server, and MongoDB using existing role-based access rules.

You can run it as a Node application or wrap it in Docker. To build manually, execute `npm install` followed by `npm run build`. If you prefer isolation, build the image via `docker build -t df-mcp .` and run it with the container flags shown in the setup instructions.

Without Node 22.10.0 or higher, local execution fails immediately due to runtime incompatibilities. You also need an accessible instance address in `DREAMFACTORY_URL` and an active key in `DREAMFACTORY_API_KEY`.

## Requirements
- Needs: Docker

## Install

### Claude Code (native platform)

**Install**
- The MCP registry has no launch command for it: see the repository README

## When to use it
- query records across PostgreSQL, MySQL, and Microsoft SQL Server
- inspect schemas and collections in MongoDB through REST endpoints
- enforce role-based permissions between the assistant and data storage
- interact with enterprise datasets without exposing raw database credentials

## Example prompts
- Query recent orders from the PostgreSQL service through DreamFactory
- Inspect the schema of the customers table via the DreamFactory API
- Retrieve matching documents from our MongoDB instance using DreamFactory

## Similar
- [database-management-patterns](https://affpapa.org/en/nevibecode/skills/database-management-patterns.md) — skill · 467 installs
- [databases](https://affpapa.org/en/nevibecode/skills/databases.md) — skill · 447 installs
- [database-optimizer](https://affpapa.org/en/nevibecode/agents/qdhenry-database-optimizer.md) — subagent · ★ 1357 repo stars
- [azure-data-api-builder](https://affpapa.org/en/nevibecode/skills/azure-data-api-builder.md) — skill · 171 installs
- [whodb](https://affpapa.org/en/nevibecode/plugins/whodb.md) — plugin · ★ 5065 repo stars
- [705-technologies-nosql-mongodb](https://affpapa.org/en/nevibecode/skills/705-technologies-nosql-mongodb.md) — skill · 216 installs

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
