# MCP MySQL Server

This is a generated Model Context Protocol (MCP) server designed to interact with a MySQL database in a read-only fashion, providing schema inspection and custom query capabilities.

## Setup Instructions

1.  **Create a folder**: Create a new directory for your server, for example, `my-mcp-server`.

    ```bash
    mkdir my-mcp-server
    cd my-mcp-server
    ```

2.  **Save the files**: Place `package.json`, `tsconfig.json`, `index1.ts`, and `README.md` into this new directory.

3.  **Install dependencies**: Open your terminal in the `my-mcp-server` directory and run:

    ```bash
    npm install
    ```

4.  **Build the project**: Compile the TypeScript code:

    ```bash
    npm run build
    ```


## Available Tools

This server exposes the following tools:

*   **`list_tables()`**: Lists all tables in the connected MySQL database.
*   **`describe_table(tableName: string)`**: Describes the columns of a specified table.
*   **`execute_read_query(query: string, params?: any[])`**: Executes a read-only SQL query (SELECT, SHOW, DESCRIBE) against the database.

# With Cursor