Value Proposition Empower autonomous agent capabilities by orchestrating complex, multi-step database operations within a unified, high-performance execution context. Significantly reduce network latency and maximize token efficiency. Read the full value proposition.

// Get all tables and their row counts in one call
const tables = await mysql.core.listTables();
const results = [];
for (const t of tables.tables) {
  const count = await mysql.core.readQuery(
    `SELECT COUNT(*) as n FROM \`${t.name}\``,
  );
  results.push({ table: t.name, rows: count.rows[0].n });
}
return results;

The mysql object exposes all other tool groups via the API. Use mysql.help() in Code Mode. This lists all available tools and categories:

Tool names strip prefixes and convert to camelCase. A key exception exists:

• Core tools map to mysql.core
• Non-core tool groups map to their respective namespace.

Common tools accept positional arguments for convenience:

// These are equivalent:
await mysql.core.readQuery("SELECT * FROM users");
await mysql.core.readQuery({ query: "SELECT * FROM users" });

// Full API overview
mysql.help();
// Group-specific help with examples
mysql.core.help();

Note: The complete Code Mode API reference is available to agents dynamically. Gotchas and tool parameter aliases are also included. Access these via the mysql://help and mysql://help/[group] resources.

The server automatically injects TypeScript definitions. This enables rich IntelliSense and validation. You write type-safe code validated before execution. Dynamic types enforce tool filters.

Agents can dynamically introspect the database schema during Code Mode execution. Use this to discover tables, columns, and relationships. Do this before constructing complex queries:

// Discover schema dynamically
const schema = await mysql.core.listTables();
const tableDetails = await mysql.core.describeTable(schema.tables[0].name);

// Alternatively, query INFORMATION_SCHEMA directly
const keys = await mysql.core.readQuery(`
  SELECT COLUMN_NAME, REFERENCED_TABLE_NAME 
  FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE 
  WHERE TABLE_NAME = '${schema.tables[0].name}'
`);

Code Mode replaces multiple sequential tool calls with one execution:

Telemetry Note: When using HTTP transport and the --metrics-export flag, metrics are exported via the Prometheus /metrics endpoint. This includes token usage, execution times, and sandbox telemetry.

You can run with only Code Mode enabled. This single tool provides access to an extensive suite of capabilities. It uses the mysql.* API:

{
  "mcpServers": {
    "mysql-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@neverinfamous/mysql-mcp",
        "--transport",
        "stdio",
        "--tool-filter",
        "codemode"
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your_user",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database",
        "CODEMODE_MAX_RESULT_SIZE": "102400"
      }
    }
  }
}

• Tool Filtering — Presets and custom tool filtering
• Tools — Complete tool list
• Configuration — MCP client configuration