Skip to main content
Glama
stellarcompiler

mysql-mcp

by stellarcompiler
OverviewSchemaRelated ServersScoreDiscussions
TypeScript
Remote

mysql-mcp

MySQL MCP Server for OpenAI Codex — Create, Read, Update only. No destructive operations.

Directory Tree

mysql-mcp/
├── .codex/
│   └── config.toml          ← Codex MCP registration
├── src/
│   ├── server/
│   │   ├── index.ts         ← MCP server entry (stdio transport)
│   │   ├── db.ts            ← mysql2 connection pool + query helpers
│   │   └── tools/
│   │       ├── schema.ts    ← mysql_list_databases, mysql_list_tables, mysql_describe_table
│   │       ├── read.ts      ← mysql_query  (SELECT only)
│   │       └── write.ts     ← mysql_insert, mysql_update  (no DELETE/DROP)
│   └── client/
│       └── index.ts         ← Test client — launches server + runs all tools
├── .env.example             ← Copy to .env with your credentials
├── .gitignore
├── package.json
└── tsconfig.json

Related MCP server: yooztech_mcp_mysql

Tools

Tool

Operation

readOnly

destructive

mysql_list_databases

SHOW DATABASES

✅

❌

mysql_list_tables

information_schema

✅

❌

mysql_describe_table

SHOW COLUMNS + SHOW INDEX

✅

❌

mysql_query

SELECT (guarded)

✅

❌

mysql_insert

INSERT / INSERT IGNORE

❌

❌

mysql_update

UPDATE (WHERE required)

❌

❌

Setup

# 1. Install dependencies
npm install

# 2. Configure credentials
cp .env.example .env
# edit .env with your MySQL details

# 3. Run the test client (launches server automatically)
npm run client

# 4. Or run server standalone
npm run server

Registering with Codex

Edit .codex/config.toml with your credentials — Codex will auto-launch the server.

Or register via CLI:

codex mcp add mysql \
  --env MYSQL_HOST=localhost \
  --env MYSQL_USER=mcp_user \
  --env MYSQL_PASSWORD=secret \
  --env MYSQL_DATABASE=mydb \
  -- npx tsx /path/to/mysql-mcp/src/server/index.ts

Verify in Codex TUI: /mcp

Safety Guardrails

  • mysql_query blocks INSERT/UPDATE/DELETE/DROP/TRUNCATE even if embedded in a SELECT

  • mysql_update requires a WHERE clause — updates without a condition are rejected

  • mysql_update supports dry_run: true to preview affected rows before committing

  • All identifiers (table/column names) are sanitized against injection

  • All values use ? prepared statement placeholders — never string interpolation

  • No DELETE, TRUNCATE, DROP, or ALTER tools exist

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections. Dates show when Glama detected each change.

No tool schema history has been recorded yet.

This server cannot be installed

RayrunBuild, deploy, and operate MCP servers without becoming an infrastructure team.ray.runAd

Maintenance

ActivityInactive
ResponsivenessSyncing

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Connectors

Related MCP Servers

  • MySQL MCP Server

    SuMiaoALi
    A
    license
    Not graded
    quality
    D
    maintenance
    Provides secure access to MySQL databases for AI assistants, enabling safe SQL queries, table information retrieval, and data insertion with built-in security protections.
    454
    2
    MIT
  • yooztech_mcp_mysql by yooztech

    yooztech_mcp_mysqlofficial

    yooztech
    A
    license
    Not graded
    quality
    B
    maintenance
    Enables secure read-only access to MySQL databases with automatic database inference from project context. Provides safe querying capabilities with built-in security features like parameterized queries, whitelisting, and rate limiting.
    1
    MIT

  • MySQL MCP Server

    yclenove
    A
    license
    Not graded
    quality
    C
    maintenance
    Enables safe querying and optional writing to MySQL databases via MCP tools, with support for schema inspection, connection management, and read-only mode.
    44
    3
    MIT

  • mysql-mcp-server

    xujcbiz
    A
    license
    A
    quality
    D
    maintenance
    Provides read-only MySQL query execution, database/table browsing, and table structure inspection with SQL safety validation.
    5
    23
    MIT

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/stellarcompiler/mysql-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server