D

DreamFactory

Databases MCP server Source ↗
Server spec
Install
See source repository
Transport
http
Auth
API key
Language
Not publicly specified
Tools exposed
6
Official
Community

DreamFactory is a Model Context Protocol (MCP) server that facilitates secure communication between AI agents and various database systems, including MS SQL Server, MySQL, and PostgreSQL. It is designed to simplify and standardize database interactions, ensuring agents can perform common operations like querying and updating records without directly managing database connections. Its RBAC framework adds a layer of security, making it suitable for environments where controlled access to data is critical. This server is particularly useful for developers and organizations looking to integrate AI capabilities with their existing database infrastructure. By acting as an intermediary, DreamFactory bridges the gap between AI agents and diverse data sources, enabling more efficient and secure data workflows.

Tools exposed

query_databaselist_tablescreate_recordupdate_recorddelete_recordexecute_stored_procedure

Resources

databasestablesrecordsstored_procedures

Requirements

  • A database instance (MS SQL Server, MySQL, PostgreSQL, etc.)
  • API key for authentication
  • Server hosting environment

Use cases

Automating database queries for reportingSynchronizing data across multiple databasesGenerating dynamic content based on database recordsPerforming bulk data operationsAuditing database access and changes

Pros & cons

Pros

  • Supports multiple database types
  • Secure access via RBAC
  • Simplifies database interactions for AI agents

Cons

  • Requires setup and configuration
  • Dependent on existing database infrastructure
  • Limited to supported database systems

Related MCP servers

A
Databases

http · 6 tools

The Aiven MCP server enables AI agents to navigate Aiven projects and interact with PostgreSQL®, Apache Kafka®, ClickHou...

View details Visit
B
Databases

http · 6 tools

Provides read and write access to Baserow tables, allowing an AI agent to interact with database content programmaticall...

View details Visit
C
Databases

http · 6 tools

Chroma is an open-source AI application database that provides embeddings, vector search, document storage, and full-tex...

View details Visit
C
Databases

stdio · 6 tools

This MCP server connects an AI agent to a ClickHouse database server, enabling direct querying of the database. It allow...

View details Visit
C
Databases

stdio · 6 tools

This MCP server enables interaction with Couchbase clusters using natural language. It connects an AI agent to Couchbase...

View details Visit

Compare DreamFactory

Explore the source

DreamFactory

View repository