MCPDB - Database Access MCP Server

MCPDB is a Laravel-based MCP (Model Context Protocol) server that provides Claude Desktop with secure access to multiple database connections. Through a web-based management interface, you can configure database connections and then query them directly from Claude Desktop using natural language.

Features

Multi-Database Support: Connect to MySQL, PostgreSQL, SQLite, and SQL Server databases
Web Management Interface: Easy-to-use web UI for managing database connections
MCP Integration: Seamlessly integrates with Claude Desktop via the Model Context Protocol
Secure Connection Management: Store and manage database credentials securely
SQL Query Execution: Execute SQL queries directly from Claude Desktop conversations

Prerequisites

Docker and Docker Compose (for Laravel Sail)
Node.js and npm (for frontend assets)
Claude Desktop application

Installation

1. Clone and Setup the Project

git clone <repository-url>
cd mcpdb

2. Start the Laravel Application

# Copy environment file
cp .env.example .env

# Start Docker containers
./vendor/bin/sail up -d

# Install PHP dependencies
./vendor/bin/sail composer install

# Install Node.js dependencies and build assets
./vendor/bin/sail npm install
./vendor/bin/sail npm run dev

# Run database migrations
./vendor/bin/sail artisan migrate

The application will be available at http://localhost:8000

3. Configure Database Connections

Open http://localhost:8000 in your browser
Click "Add Connection" to create database connections
Fill in the connection details:
- Connection Name: Unique identifier (e.g., "my_production_db")
- Driver: mysql, pgsql, sqlite, or sqlsrv
- Host: Database host address
- Port: Database port (optional, uses default if empty)
- Database: Database name
- Username: Database username
- Password: Database password
- Description: Optional description
Test the connection to ensure it works
Make sure "Active" is checked

4. Configure Claude Desktop

Create or edit the Claude Desktop configuration file:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json Windows: %APPDATA%\Claude\claude_desktop_config.json

Add the following configuration:

{
  "mcpServers": {
    "mcpdb": {
      "command": "npx",
      "args": [
        "mcp-remote",
        "http://localhost:8000/mcp"
      ]
    }
  }
}

5. Install mcp-remote (if not already installed)

npm install -g mcp-remote

6. Restart Claude Desktop

Completely quit and restart Claude Desktop for the configuration to take effect.

Usage

Once configured, you can interact with your databases directly through Claude Desktop:

List Available Connections

What database connections are available?

Execute SQL Queries

Execute this SQL query on the "my_production_db" connection: SELECT * FROM users LIMIT 5

Show me the table structure for the products table in the inventory database

Count the number of orders in the last 30 days using the sales_db connection

Available MCP Tools

The server provides two main tools:

list_connections: Lists all active database connections
execute_sql: Executes SQL queries on specified connections

Development

Project Structure

app/Models/SubjectConnection.php - Database connection model
app/Http/Controllers/ConnectionController.php - Web interface for managing connections
app/Http/Controllers/McpController.php - MCP server implementation
resources/views/connections/ - Web interface views
database/migrations/ - Database schema migrations

Running Tests

./vendor/bin/sail artisan test

Code Formatting

./vendor/bin/sail artisan pint

Security Considerations

Database passwords are stored in the application database
Only active connections are exposed to the MCP server
SQL queries are executed with the permissions of the configured database user
Consider using read-only database users for security
The MCP server runs on localhost only by default

Troubleshooting

MCP Server Not Connecting

Ensure Laravel server is running: ./vendor/bin/sail up -d
Check MCP server health: curl http://localhost:8000/health
Verify Claude Desktop configuration file syntax
Check Claude Desktop logs: ~/Library/Logs/Claude/

Database Connection Failures

Test connections in the web interface: http://localhost:8000
Verify database credentials and network access
Check if database user has appropriate permissions
For remote databases, ensure firewall allows connections

Asset Loading Issues

# Rebuild frontend assets
./vendor/bin/sail npm run dev

Contributing

Fork the repository
Create a feature branch
Make your changes
Run tests and ensure code formatting
Submit a pull request

License

This project is open-sourced software licensed under the MIT license.

This server cannot be installed

security - not tested

license - not found

quality - not tested

Provides Claude Desktop with secure access to multiple database connections, allowing users to query MySQL, PostgreSQL, SQLite, and SQL Server databases directly through natural language.

Related MCP Servers

MCP Alchemy
runekaagaard
-
security
A
license
-
quality
Connects Claude Desktop directly to databases, allowing it to explore database structures, write SQL queries, analyze datasets, and create reports through an API layer with tools for table exploration and query execution.
Last updated -
210
Python
Mozilla Public License 2.0
MCP-Python
rhabraken
-
security
F
license
-
quality
A server that enables interaction with PostgreSQL, MySQL, MariaDB, or SQLite databases through Claude Desktop using natural language queries.
Last updated -
Python
SQL MCP Server for Claude Desktop
meanands
-
security
F
license
-
quality
A natural language interface that allows Claude to execute SQL queries on your local MySQL databases, enabling database interaction using natural language.
Last updated -
2
Python
mysqldb-mcp-server
burakdirin
-
security
A
license
-
quality
An MCP server that enables MySQL database integration with Claude. You can execute SQL queries and manage database connections.
Last updated -
1
Python
MIT License

View all related MCP servers

MCPDB - Database Access MCP Server