mysql-mcp
Provides tools to interact with MySQL databases: list databases, list tables, describe table schema, execute SELECT queries, insert and update rows with safety guardrails.
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
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.jsonRelated MCP server: yooztech_mcp_mysql
Tools
Tool | Operation | readOnly | destructive |
| SHOW DATABASES | ✅ | ❌ |
| information_schema | ✅ | ❌ |
| SHOW COLUMNS + SHOW INDEX | ✅ | ❌ |
| SELECT (guarded) | ✅ | ❌ |
| INSERT / INSERT IGNORE | ❌ | ❌ |
| 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 serverRegistering 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.tsVerify in Codex TUI: /mcp
Safety Guardrails
mysql_queryblocks INSERT/UPDATE/DELETE/DROP/TRUNCATE even if embedded in a SELECTmysql_updaterequires a WHERE clause — updates without a condition are rejectedmysql_updatesupportsdry_run: trueto preview affected rows before committingAll identifiers (table/column names) are sanitized against injection
All values use
?prepared statement placeholders — never string interpolationNo DELETE, TRUNCATE, DROP, or ALTER tools exist
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
Safe, read-only Postgres and MySQL access for AI agents. Audit log + column-level controls.
Security layer for AI agents: Retrieve for controlled SQL reads, Guard for allow/deny writes.
MySQL change tracking with instant row-level recovery and forensic attribution for compliance.
Guard AI agents' PostgreSQL/MySQL access via MCP: SQL audit, auth, masking, write approval
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceProvides secure access to MySQL databases for AI assistants, enabling safe SQL queries, table information retrieval, and data insertion with built-in security protections.862 npm2MIT

yooztech_mcp_mysqlofficial
AlicenseNot gradedqualityDmaintenanceEnables 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.1MIT- AlicenseNot gradedqualityDmaintenanceEnables safe querying and optional writing to MySQL databases via MCP tools, with support for schema inspection, connection management, and read-only mode.28 npm3MIT
- AlicenseAqualityDmaintenanceProvides read-only MySQL query execution, database/table browsing, and table structure inspection with SQL safety validation.58 npmMIT