My Coding Buddy MCP Server

A personal MCP (Model Context Protocol) server that serves as a coding companion, providing tools to streamline development workflows. It connects to various coding clients and offers database utilities for MySQL.

Overview

This MCP server provides:

• Database introspection and query execution tools for MySQL

• Integration with coding clients like VS Code, Cursor, and others

• Extensible architecture for custom tool development

Related MCP server: Appwrite MCP Server

Setup

Install dependencies:

uv sync

MCP Configuration

Configure the server in your MCP client's configuration file (e.g., .cursor/mcp.json for Cursor):

{
  "mcpServers": {
    "coding-buddy": {
      "command": "uv",
      "args": ["--directory", "/your_repo_directory_here", "run", "server.py"]
    }
  }
}

Features

• List databases, tables, and views

• Execute SQL queries with formatted results

• Retrieve table schemas, indexes, and DDL

• Search tables by pattern

• Get row counts and column information

Usage

The server provides SQL tools that can be invoked through MCP-compatible clients. Tools include database listing, schema inspection, and query execution.

Testing

A comprehensive test script is provided to validate the SQL connection and test all SQL tool functions:

python test_sql_tools.py

The test script will:

• Verify database connection using environment variables

• Test all SQL tool functions including database listing, table operations, and query execution

• Provide detailed output for each test case

Make sure your .env file contains the required database credentials:

• SQL_HOST

• SQL_USER

• SQL_PASSWORD

• SQL_DATABASE

Contributing

Contributions are welcome. Submit pull requests or open issues for feature requests and bug reports.

Learn More

For more information about the MCP protocol, visit the official MCP documentation.