MCP Server LogoMCP Server
MCPsCategoriesDirectorySubmit
Submit
MCPsCategoriesDirectorySubmit
Submit

MCP Servers

A curated list of MCP Servers, featuring Awesome MCP Servers and Claude MCP integration.

Contact Us

[email protected]

About

Privacy PolicyTerms of Service

Resources

Model Context ProtocolMCP Starter GuideClaude MCP Servers

Community

GitHub

© 2026 mcpserver.cc © 2025 MCP Server. All rights reserved.

Privacy PolicyTerms of Service
  1. Home
  2. /Categories
  3. /Data & Storage
  4. /Mcp Db Navigator
Mcp Db Navigator

Mcp Db Navigator

Created by Medsaad•9 months ago
Visit Website

A powerful MySQL/MariaDB database navigation MCP (Model Control Protocol) to be installed in Cursor, Claude or other tools that accept mcps for easy database querying and management.

Data & Storage
MySQLdatabase-navigationMCP

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:

mkdir $env:USERPROFILE.mcp

macOS/Linux:

mkdir -p ~/.mcp

Installation

From PyPI (recommended for most users):

pip install mcp-db-navigator

From source (for development):

git clone <your-repo-url>
cd mcp-db
pip install -e .
  1. Create a .env file with your database credentials:
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:

mcp-db --config /path/to/your/project/.env

2. In Cursor

To use this MCP server in Cursor:

  • Open Cursor settings and add a new MCP server.
  • Use the following configuration (example):
{
  "mcpServers": {
    "mysql-navigator": {
      "command": "mcp-db",
      "args": [
        "--config",
        "/absolute/path/to/your/.env"
      ]
    }
  }
}
  • Make sure the path to your .env file is absolute.

3. In Claude Desktop

If Claude Desktop supports MCP servers:

  • Add a new MCP server and point it to the mcp-db command with the --config argument as above.
  • Refer to Claude Desktop’s documentation for details on adding custom MCP servers.

Query Parameters

The query dictionary supports the following parameters:

  • table_name (required): Name of the table to query
  • select_fields (optional): List of fields to select (defaults to [“*”])
  • where_conditions (optional): Dictionary of field-value pairs for WHERE clause
  • order_by (optional): List of fields to order by
  • order_direction (optional): Sort direction “ASC” or “DESC” (default: “ASC”)
  • limit (optional): Number of records to return
  • offset (optional): Number of records to skip
  • group_by (optional): List of fields to group by
  • having (optional): Dictionary of field-value pairs for HAVING clause
  • join_table (optional): Name of the table to join with
  • join_type (optional): Type of JOIN operation (default: “INNER”)
  • join_conditions (optional): Dictionary of join conditions

Security Features

  • Database credentials are managed through a config file
  • Passwords are stored as SecretStr in Pydantic models
  • Input validation for all query parameters
  • SQL injection prevention through parameterized queries
  • SSL/TLS support for encrypted connections
  • Connection string sanitization
  • Rate limiting for queries
  • Query parameter sanitization

Production Features

Error Handling

  • Comprehensive error handling for database operations
  • Connection timeout handling
  • Automatic retry mechanism for failed connections
  • Input validation for all parameters

Performance

  • Connection pooling for optimal resource usage
  • Query execution time logging
  • Connection pool statistics
  • Performance metrics collection

Monitoring

  • Structured logging with different log levels
  • Query execution tracking
  • Connection state monitoring
  • Error rate tracking

Contributing

  1. Fork the repository
  2. Create your feature branch (git checkout -b feature/amazing-feature)
  3. Commit your changes (git commit -m 'Add some amazing feature')
  4. Push to the branch (git push origin feature/amazing-feature)
  5. Open a Pull Request

License

This project is licensed under the MIT License - see the LICENSE file for details.

Prerequisites

  • •Familiarity with the server domain
  • •Basic understanding of related technologies
  • •Knowledge of Data & Storage

Recommended Server

Findmine Mcp

Findmine Mcp

MCP server for FindMine's product styling AI

Dubco Mcp Server

Dubco Mcp Server

MCP server for Dub.co link shortener API integration

Slim Mcp

Slim Mcp

View more → →

Details

Created

June 12, 2025

Last Updated

June 12, 2025

Category

Data & Storage

Author

Medsaad

Share

More Server

Mcp Crypto Price

Mcp Crypto Price

A Model Context Protocol (MCP) server that provides real-time cryptocurrency analysis via CoinCap's API. Enables Claude and other MCP clients to fetch crypto prices, analyze market trends, and track historical data.

Mcp Clickup

Mcp Clickup

Mcp Brianknows

Mcp Brianknows

Unofficial MCP to use BrianKnows API for DeFI knowledge

Tavily Search Mcp Server

Tavily Search Mcp Server

An MCP server implementation that integrates the Tavily Search API, providing optimized search capabilities for LLMs.