mysqlInteractor

mysqlInteractor is a library written in TypeScript that simplifies interactions with MySQL databases. It efficiently handles database connections, executes queries, and retrieves results, allowing developers to focus on database operations without unnecessary complexity.

GitHub Stars

1

User Rating

Not Rated

Favorites

0

Views

36

Forks

0

Issues

0

README
mysqlInteractor

MysqlInteractor is simple MCP server that works with any host with MCP client(ex: claude desktop). It allow direct interaction with any database in mysql servers.

Result

image

update mysql credentials

In index.ts put your host, user and password in :

    const connection = await mysql.createConnection({
      host: 'localhost',
      user: 'root',
      password: 'root',
      database: db
    });

then run :

    npm run build
Claude desktop integration

Add this to your claude_desktop_config.json (File->settings->Developer->Claude settings -> configure):

  "mysql-interactor": {
      "command": "node",
      "args": [
        "path\\to\\mysqlInteractor\\build\\index.js"
      ]
    }
Usage
Give me the number of flights by departure airport in flights booking database