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

1. Open http://localhost:8000 in your browser
2. Click "Add Connection" to create database connections
3. 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
4. Test the connection to ensure it works
5. 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:

1. list_connections: Lists all active database connections
2. 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

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

Database Connection Failures

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

Asset Loading Issues

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

Contributing

1. Fork the repository
2. Create a feature branch
3. Make your changes
4. Run tests and ensure code formatting
5. Submit a pull request

License

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