Explore
Contribute
Sign In
DreamFactory

DreamFactory

mcp

DreamFactory is a REST API generation platform with support for hundreds of data sources, including Microsoft SQL Server, MySQL, PostgreSQL, and MongoDB. The DreamFactory MCP Server makes it easy for users to securely interact with their data sources via an MCP client.

10K+

8 Tools

Packaged by
Add to Docker Desktop

Version 4.43 or later needs to be installed to add the server automatically

OverviewTools (8)Config
Docker Hub⁠Github repository⁠

Use cases

Call a stored function

Call a stored procedure

Get stored functions available in the database

Get stored procedures available in the database

Retrieve the data of a specific table

Retrieve the schema of a specific table

Get tables available in the database

List available tools

About

DreamFactory MCP Server

DreamFactory is a REST API generation platform with support for hundreds of data sources, including Microsoft SQL Server, MySQL, PostgreSQL, and MongoDB. The DreamFactory MCP Server makes it easy for users to securely interact with their data sources via an MCP client.

What is an MCP Server?⁠

MCP Info

AttributeDetails
Docker Imagemcp/df-mcp⁠
Authordreamfactorysoftware⁠
Repositoryhttps://github.com/dreamfactorysoftware/df-mcp⁠

Image Building Info

AttributeDetails
Dockerfilehttps://github.com/dreamfactorysoftware/df-mcp/blob/9d570ce983635c597b5b6856c1634f2d1328ede7/Dockerfile⁠
Commit9d570ce983635c597b5b6856c1634f2d1328ede7
Docker Image built byDocker Inc.
Docker Scout Health ScoreDocker Scout Health Score
Verify SignatureCOSIGN_REPOSITORY=mcp/signatures cosign verify mcp/df-mcp --key https://raw.githubusercontent.com/docker/keyring/refs/heads/main/public/mcp/latest.pub
LicenceApache License 2.0

Available Tools (8)

Tools provided by this ServerShort Description
call-stored-functionCall a stored function
call-stored-procedureCall a stored procedure
get-stored-functionsGet stored functions available in the database
get-stored-proceduresGet stored procedures available in the database
get-table-dataRetrieve the data of a specific table
get-table-schemaRetrieve the schema of a specific table
get-tablesGet tables available in the database
list-toolsList available tools

Tools Details

Tool: call-stored-function

Call a stored function

ParametersTypeDescription
functionNamestring
Tool: call-stored-procedure

Call a stored procedure

ParametersTypeDescription
procedureNamestring
Tool: get-stored-functions

Get stored functions available in the database

Tool: get-stored-procedures

Get stored procedures available in the database

Tool: get-table-data

Retrieve the data of a specific table

ParametersTypeDescription
tableNamestring
continuebooleanoptionalIn batch scenarios where supported, continue processing even after one action fails. Default behavior is to halt and return results up to the first point of failure.
fieldsarrayoptional
filterstringoptionalSQL-like filter to limit the records to retrieve.
groupstringoptionalComma-delimited list of the fields used for grouping of filter results.
limitnumberoptionalLimit for pagination.
offsetnumberoptionalOffset for pagination.
orderstringoptionalSQL-like order containing field and direction for filter results.
relatedstringoptionalComma-delimited list of related names to retrieve for each resource. (it will be found in the related field of the schema)
Tool: get-table-schema

Retrieve the schema of a specific table

ParametersTypeDescription
tableNamestring
Tool: get-tables

Get tables available in the database

Tool: list-tools

List available tools

Use this MCP Server

{
  "mcpServers": {
    "dreamfactory-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "DREAMFACTORY_URL",
        "-e",
        "DREAMFACTORY_API_KEY",
        "mcp/df-mcp"
      ],
      "env": {
        "DREAMFACTORY_URL": "https://your-dreamfactory-instance.com/api/v2/your-api",
        "DREAMFACTORY_API_KEY": "1234abcd1234abdd"
      }
    }
  }
}

Why is it safer to run MCP Servers with Docker?⁠

Related servers