A
licenseNot graded
qualityC
maintenanceA Model Context Protocol server that provides read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.
11,052 npm
2,108
MIT
MCP MySQL Server
Provides read-only access to MySQL databases with schema inspection capabilities, allowing listing of tables, describing table structures, and executing SELECT queries.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@MCP MySQL Serverdescribe_table users"
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 MySQL Server
This is a generated Model Context Protocol (MCP) server designed to interact with a MySQL database in a read-only fashion, providing schema inspection and custom query capabilities.
Setup Instructions
Create a folder: Create a new directory for your server, for example,
my-mcp-server.mkdir my-mcp-server cd my-mcp-serverSave the files: Place
package.json,tsconfig.json,index1.ts, andREADME.mdinto this new directory.Install dependencies: Open your terminal in the
my-mcp-serverdirectory and run:npm installBuild the project: Compile the TypeScript code:
npm run build
Related MCP server: MCP Server for MySQL
Available Tools
This server exposes the following tools:
list_tables(): Lists all tables in the connected MySQL database.describe_table(tableName: string): Describes the columns of a specified table.execute_read_query(query: string, params?: any[]): Executes a read-only SQL query (SELECT, SHOW, DESCRIBE) against the database.
With Cursor
This server cannot be deployed
Maintenance
ActivityInactive
ResponsivenessNo issues
Related MCP Connectors
Safe, read-only Postgres and MySQL access for AI agents. Audit log + column-level controls.
- dataOAuthco.thinair
Read-only PostgreSQL, MySQL, SQL Server access via MCP — 24 dialect-aware hosted tools.
Read-only access to your CodeMouse accounts, repositories, and AI pull-request reviews.
Generate, fix, explain and run read-only SQL on PostgreSQL, MySQL and SQL Server
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceA Model Context Protocol server providing read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.13 npm1MIT
- AlicenseNot gradedqualityDmaintenanceA Model Context Protocol server that provides read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.11,052 npmMIT
- AlicenseNot gradedqualityDmaintenanceA Model Context Protocol server providing read-only access to MySQL databases, enabling LLMs to inspect database schemas and execute read-only queries.317 npm1MIT