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
- 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
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
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 modelapp/Http/Controllers/ConnectionController.php - Web interface for managing connectionsapp/Http/Controllers/McpController.php - MCP server implementationresources/views/connections/ - Web interface viewsdatabase/migrations/ - Database schema migrations
Running Tests
./vendor/bin/sail artisan test
./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.