DreamFactory MCP Server

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.

284

8 Tools

Packaged by

Add to Docker Desktop

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

Overview Tools (8)Config Manual installation

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 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?⁠

Characteristics

Attribute	Details
Docker Image	mcp/df-mcp⁠
Author	dreamfactorysoftware⁠
Repository	https://github.com/dreamfactorysoftware/df-mcp⁠
Dockerfile	https://github.com/dreamfactorysoftware/df-mcp/blob/master/Dockerfile⁠
Docker Image built by	Docker Inc.
Docker Scout Health Score
Verify Signature	`COSIGN_REPOSITORY=mcp/signatures cosign verify mcp/df-mcp --key https://raw.githubusercontent.com/docker/keyring/refs/heads/main/public/mcp/latest.pub`
Licence	Apache License 2.0

Available Tools (8)

Tools provided by this Server	Short Description
`call-stored-function`	Call a stored function
`call-stored-procedure`	Call a stored procedure
`get-stored-functions`	Get stored functions available in the database
`get-stored-procedures`	Get stored procedures available in the database
`get-table-data`	Retrieve the data of a specific table
`get-table-schema`	Retrieve the schema of a specific table
`get-tables`	Get tables available in the database
`list-tools`	List available tools

Tools Details

Tool: `call-stored-function`

Call a stored function

Parameters	Type	Description
`functionName`	`string`

Tool: `call-stored-procedure`

Call a stored procedure

Parameters	Type	Description
`procedureName`	`string`

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

Parameters	Type	Description
`tableName`	`string`
`continue`	`boolean`optional	In 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.
`fields`	`array`optional
`filter`	`string`optional	SQL-like filter to limit the records to retrieve.
`group`	`string`optional	Comma-delimited list of the fields used for grouping of filter results.
`limit`	`number`optional	Limit for pagination.
`offset`	`number`optional	Offset for pagination.
`order`	`string`optional	SQL-like order containing field and direction for filter results.
`related`	`string`optional	Comma-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

Parameters	Type	Description
`tableName`	`string`

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?⁠

Manual installation

You can install the MCP server using:

Installation for

Related servers