Which integrations are available for this server?

Provides tools to explore MariaDB database schemas, including tables, columns, foreign keys, indexes, and relationships, supporting MariaDB 10.2+. Provides tools to explore MySQL database schemas, including tables, columns, foreign keys, indexes, and relationships, via MCP.

How do I use mcp-server-mysql-schema?

1. Click on "Deploy Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@mcp-server-mysql-schema show columns of users table in myapp" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

mcp-server-mysql-schema

by rendi-febrian

Overview Schema Source Related Servers Discussions Admin

TypeScript

Hybrid

mcp-server-mysql-schema

MySQL Schema MCP Server — explore tables, columns, foreign keys, indexes, and relationships through the Model Context Protocol. Works with opencode, Claude Desktop, Cursor, and any MCP-compatible AI client.

No more writing SHOW TABLES and DESCRIBE manually. Ask your AI assistant "what tables are in this database?", "show me the foreign keys of the orders table", or "find all columns named 'status'" — and get structured JSON responses.

Quick Start

# Install
npx mcp-server-mysql-schema

# Or clone
git clone git@github.com:rendi-febrian/mcp-server-mysql-schema.git
cd mcp-server-mysql-schema
npm install && npm run build

opencode Configuration

{
  "mcp": {
    "mysql-schema": {
      "type": "local",
      "command": ["node", "/path/to/mcp-server-mysql-schema/dist/index.js"],
      "environment": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "your-password"
      },
      "enabled": true
    }
  }
}

Claude Desktop / Cursor / Other MCP Clients

{
  "mcpServers": {
    "mysql-schema": {
      "command": "node",
      "args": ["/path/to/mcp-server-mysql-schema/dist/index.js"],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "your-password"
      }
    }
  }
}

Related MCP server: easy-mysql-mcp

Features

Tools

Tool	Description	Example
`schema_databases`	List all non-system databases with charset	`schema_databases()`
`schema_tables`	All tables — engine, row count, auto-increment, comments	`schema_tables(database: "myapp")`
`schema_views`	All views in a database	`schema_views(database: "myapp")`
`schema_table_detail`	Columns: type, nullable, default, key, extra, comment	`schema_table_detail(database: "myapp", table: "users")`
`schema_foreign_keys`	FK relationships — all DB, per-table, incoming/outgoing	`schema_foreign_keys(database: "myapp", table: "orders")`
`schema_indexes`	Indexes: name, columns, seq, unique, type, comment	`schema_indexes(database: "myapp", table: "users")`
`schema_relationships`	Full PK/FK map across all tables	`schema_relationships(database: "myapp")`
`schema_search`	Search table and column names by keyword	`schema_search(database: "myapp", keyword: "user")`

Resources

URI	Content
`schema://{db}/tables`	All tables in the database
`schema://{db}/relationships`	Full relationship map
`schema://{db}/{table}/columns`	Column details
`schema://{db}/{table}/indexes`	Index details
`schema://{db}/{table}/foreign-keys`	Foreign key details

Security

100% read-only. Every query targets information_schema only. No SELECT on user tables. No INSERT, UPDATE, DELETE, or DDL. The server cannot modify any data.

Why Not Just Use MySQL MCP?

	MySQL MCP	Schema MCP (this)
Purpose	Run arbitrary SQL	Introspect database structure
Query target	Any table / any query	`information_schema` only
Write access	Optional (configurable)	Never
Structured tools	Single `mysql_query` tool	8 focused tools
Resources	Table-level	Table + FK + relationship maps
Best for	Data CRUD, ad-hoc queries	Schema discovery, ERD, migrations

Requirements

Node.js >= 18
MySQL 5.7+ or MariaDB 10.2+
MySQL user with SELECT on information_schema (default)

Environment Variables

Variable	Required	Default	Description
`MYSQL_HOST`	No	`127.0.0.1`	MySQL host
`MYSQL_PORT`	No	`3306`	MySQL port
`MYSQL_USER`	No	`root`	MySQL user
`MYSQL_PASS`	No	`""`	MySQL password
`MYSQL_DEFAULT_DB`	No	—	Default database for resource URIs

Architecture

src/
├── index.ts              # MCP server entry point (raw Server)
├── db.ts                 # MySQL connection pool
├── schema.ts             # information_schema queries
├── tools/
│   ├── tables.ts         # schema_databases, schema_tables, schema_views
│   ├── detail.ts         # schema_table_detail
│   ├── foreignKeys.ts    # schema_foreign_keys
│   ├── indexes.ts        # schema_indexes
│   ├── relationships.ts  # schema_relationships
│   └── search.ts         # schema_search
└── resources/
    └── index.ts          # schema:// URIs

No ORM, no migrations, no configuration files — just raw information_schema queries over mysql2.

Contributing

See CONTRIBUTING.md.

License

MIT

Available Tools

8 tools

schema_databasesA

List all non-system MySQL databases with charset and collation

Inputs: no named parameters.

schema_foreign_keysB

List foreign key relationships for a database or specific table (incoming + outgoing)

Inputs: database (required), table, direction.

schema_indexesA

List all indexes for a table with columns, uniqueness, and type

Inputs: table (required), database (required).

schema_relationshipsB

Full relationship map across all tables in a database: primary keys, foreign keys, and references

Inputs: database (required).

schema_searchB

Search across table and column names in a database

Inputs: keyword (required), database (required).

schema_table_detailB

Show columns, types, defaults, nullable, keys, and comments for a table

Inputs: table (required), database (required).

schema_tablesA

List all tables in a database with engine, row count, size estimates, and comments

Inputs: database (required).

schema_viewsB

List all views in a database

Inputs: database (required).

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

Deploy Server

Claude Code, inside the Godot 4 editorFlockbay puts an AI agent in the real Godot 4 editor: it writes GDScript, runs your game and fixes what breaks. Free, or bring your own Claude Code or Codex.flockbay.comAd

TDQS

A3.9/5.0

Scored 2026-07-09 11:00 across 8 tools

Disambiguation5/5

Each tool has a clearly distinct purpose: databases, foreign keys, indexes, relationships, search, table details, tables, and views. No two tools overlap in function.

Naming Consistency5/5

All tool names follow a consistent 'schema_noun' pattern using snake_case, making it easy to predict what each tool does.

Tool Count5/5

With 8 tools, the server is well-scoped for MySQL schema exploration. Each tool covers a distinct aspect without excessive granularity.

Completeness4/5

The set covers essential schema exploration: databases, tables, columns, indexes, foreign keys, relationships, views, and search. Missing stored procedures or events, but these are not core to schema inspection.

Maintenance

ActivityInactive

ResponsivenessNo recent community issues

Resources

Related MCP Connectors

data
co.thinair
PostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.
Databases Developer Tools
2
https://data.thinair.co/mcp
QueryBear
io.github.spencerpauly
Safe, read-only Postgres and MySQL access for AI agents. Audit log + column-level controls.
Databases RAG Systems
2
https://mcp.querybear.com/mcp
wgong-sqlite-mcp-server
ai.smithery
Explore, query, and inspect SQLite databases with ease. List tables, preview results, and view det…
Databases Developer Tools
21
https://server.smithery.ai/@wgong/sqlite-mcp-server/mcp
Schema
ai.schemalabs
The AI that understands raw data: Schema over your tables and databases, as MCP tools.
Databases Developer Tools
1
https://mcp.schemalabs.ai/mcp

Related MCP Servers

MCP MySQL Server
Databases Developer Tools
Iceeeeec
A
license
Not graded
quality
D
maintenance
Enables AI assistants to safely query MySQL databases with read-only access by default, supporting table listing, structure inspection, and SQL queries with optional write operation control.
Updated a year ago (2025-11-06 03:02 UTC)
12 npm
MIT
easy-mysql-mcp
Databases Developer Tools
chenkumi
A
license
A
quality
C
maintenance
Enables AI assistants to inspect and query a MySQL database through safe, structured tools, including schema discovery and read-only queries.
Updated 2 months ago (2026-09-08 17:46 UTC)
9
57 npm
MIT
Simple MCP MySQL Server
Databases Developer Tools
alexcc4
F
license
Not graded
quality
D
maintenance
Enables AI assistants to securely interact with MySQL databases, including listing tables, viewing schemas, and executing read-only SQL queries through natural language.
Updated 2 years ago (2025-03-09 15:57 UTC)
7
-
MySQL MCP Server
Databases Developer Tools
eltonf
A
license
Not graded
quality
D
maintenance
Enables schema introspection and safe read-only queries on MySQL databases, supporting table/column discovery, relationship exploration, and controlled SELECT queries.
Updated 6 months ago (2026-05-11 20:29 UTC)
17 npm
MIT

mcp-server-mysql-schema

Quick Start

opencode Configuration

Claude Desktop / Cursor / Other MCP Clients

Features

Tools

Resources

Security

Why Not Just Use MySQL MCP?

Requirements

Environment Variables

Architecture

Contributing

License

Available Tools

Tool Schema Changelog

TDQS

Maintenance

Resources

Related MCP Connectors

Related MCP Servers

MCP MySQL Server

easy-mysql-mcp

Simple MCP MySQL Server

MySQL MCP Server