LabStore
← All labs

DreamFactory

by docker ✓ verified ✓ Packaged by Docker

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.

MCP server installable needs setup network: on runtime: sysbox

Databases MCP Servers

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

Attribute Details
Docker Image mcp/df-mcp
Author dreamfactorysoftware
Repository https://github.com/dreamfactorysoftware/df-mcp

Image Building Info

Attribute Details
Dockerfile https://github.com/dreamfactorysoftware/df-mcp/blob/9d570ce983635c597b5b6856c1634f2d1328ede7/Dockerfile
Commit 9d570ce983635c597b5b6856c1634f2d1328ede7
Docker Image built by Docker Inc.
Docker Scout Health Score 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?