Which integrations are available for this server?

Allows interaction with MySQL databases, enabling AI agents to execute SQL queries (SELECT, INSERT, UPDATE, DELETE, DDL), list and describe tables, get table schemas, explain query execution plans, and verify database connectivity.

How do I use OpenCode MySQL Connector?

1. Click on "Install 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., "@OpenCode MySQL Connector list all tables with row counts" 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.

OpenCode MySQL Connector

A MySQL MCP (Model Context Protocol) server for OpenCode. Provides tools to query and explore MySQL databases via stdio transport.

Environment Variables

Variable	Required	Default
`MYSQL_HOST`	Yes	—
`MYSQL_PORT`	No	`3306`
`MYSQL_USER`	Yes	—
`MYSQL_PASSWORD`	Yes	—
`MYSQL_DATABASE`	Yes	—

Related MCP server: MySQL Custom MCP Server

Tools

Tool	Description
`execute_query`	Execute a MySQL SQL query (SELECT, INSERT, UPDATE, DELETE, DDL). Supports parameterized queries.
`list_tables`	List tables in a database with optional row counts and a `LIKE` name filter.
`describe_table`	Get table structure: columns, types, nullability, keys, and defaults.
`explain_query`	Get the EXPLAIN execution plan for a SQL query.
`get_schema`	Get the DDL (CREATE TABLE) for all tables in a database.
`check_connection`	Verify the connector can reach the MySQL server.

Prompts

Prompt	Description
`show_table_context`	Get a ready-to-use table schema context for a given table name.

Setup

npm install
npm run build

Usage

MYSQL_HOST=localhost \
MYSQL_USER=root \
MYSQL_PASSWORD=secret \
MYSQL_DATABASE=mysqldatabase \
MYSQL_PORT=3306 \
npm start

License

ISC

This server cannot be installed

F

license - not found

-

quality - not tested

-

maintenance - not tested

How are these scores calculated?

Resources

GitHub Repository

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

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

OpenCode MySQL Connector

OpenCode MySQL Connector

Environment Variables

Tools

Prompts

Setup

Usage

License

Resources

Looking for Admin?

Latest Blog Posts

MCP directory API