mcp-db-navigator

# MySQL Navigator MCP A powerful MySQL/MariaDB database navigation tool using MCP (Model Control Protocol) for easy database querying and management. ## Features - Connect to MySQL/MariaDB databases - Switch between different databases dynamically - Execute SQL queries with type safety - Retrieve database schema information - Pydantic model validation for query parameters - Secure credential management - Comprehensive logging system - Connection pooling and retry mechanisms - SSL/TLS support for secure connections ## Log File Location (Cross-Platform) By default, all logs are written to: - **Windows:** `C:\Users\<YourUsername>\.mcp\mcp-db.log` - **macOS/Linux:** `/home/<yourusername>/.mcp/mcp-db.log` or `/Users/<yourusername>/.mcp/mcp-db.log` If the `.mcp` folder does not exist in your home directory, the application will automatically create it. If you run into any issues, you can manually create the folder: **Windows:** ```powershell mkdir $env:USERPROFILE\.mcp ``` **macOS/Linux:** ```bash mkdir -p ~/.mcp ``` ## Installation ### From PyPI (recommended for most users): ```bash pip install mcp-db-navigator ``` ### From source (for development): ```bash git clone <your-repo-url> cd mcp-db pip install -e . ``` 3. Create a `.env` file with your database credentials: ```env DB_HOST=your_host DB_PORT=your_port DB_NAME=your_database_name DB_USER=your_username DB_PASSWORD=your_password DB_SSL_CA=/path/to/ssl/ca.pem # Optional: for SSL/TLS connections DB_MAX_RETRIES=3 # Optional: number of connection retries DB_RETRY_DELAY=1.0 # Optional: delay between retries in seconds ``` ## Usage Examples ### 1. Command Line Run the MCP server directly from your terminal: ```bash mcp-db --config /path/to/your/project/.env ``` ### 2. In Cursor To use this MCP server in [Cursor](https://www.cursor.so): - Open Cursor settings and add a new MCP server. - Use the following configuration (example): ```json { "mcpServers": { "mysql-navigator": { "command": "mcp-…