# 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

## Setup

Install dependencies:

```bash
uv sync
```

## MCP Configuration

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

```json
{
  "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:

```bash
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.