MySQL Natural Language Agent

What it does

AgenteMySQL bridges plain-language questions and MySQL/MariaDB databases. Powered by Ollama running the Gemma 3 model locally, it translates natural-language prompts into valid SQL queries and executes them against your database — keeping all data and inference fully on-premise.

Tools

• natural_query — Accepts a free-text question and returns the generated SQL plus query results from your MySQL/MariaDB database.
• get_schema — Reads the current database schema so the model can generate accurate, context-aware queries.

Installation

Clone the repo and configure a .env file with your database credentials:

git clone https://github.com/MartinMedinaRuvian/agentemysql
cd agentemysql
npm install

Create .env:

DB_HOST=localhost
DB_USER=your_user
DB_PASSWORD=your_password
DB_NAME=your_database

Start in order using the provided .bat scripts (Windows) or run the Node services directly:

1. node mcp/index.js — MCP server
2. node api/server.js — REST API
3. Ensure Ollama is running with ollama run gemma3:12b
4. node api/server_agente.js — Agent API

Open index.html in a browser to interact.

{
  "mcpServers": {
    "agentemysql": {
      "command": "node",
      "args": ["mcp/index.js"],
      "cwd": "/path/to/agentemysql"
    }
  }
}

Supported hosts

No specific MCP client confirmed in the README. Works with any stdio-compatible MCP host.