Skip to main content
Glama
siimleetberg

OpenCode MySQL Connector

by siimleetberg
OverviewSchemaRelated ServersScoreDiscussions
TypeScript
Remote

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 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.

switch_schema

Switch the active database used by subsequent tools that do not specify one.

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

Install Server
F
license - not found
C
quality
C
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

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

Tools

Related MCP Servers

  • mysql-mcp

    eastgatedev
    A
    license
    Not graded
    quality
    B
    maintenance
    A MySQL MCP server for local stdio clients, enabling database queries and management with read-only/write modes, audit logging, and configurable security.
    655
    MIT

  • MySQL MCP Server

    iamdylanngo
    A
    license
    C
    quality
    C
    maintenance
    Connects MCP-compatible clients like Claude to a MySQL database, enabling schema inspection and read/write queries via stdio transport.
    5
    519
    1
    MIT

  • MySQL Ops MCP

    lemonq3q
    F
    license
    Not graded
    quality
    C
    maintenance
    A generic MCP server for MySQL operations, enabling listing databases/tables, describing schemas, running read-only SQL, and optionally executing write SQL with logging.
    1

  • SQL Database Bridge

    alizaimovic
    A
    license
    Not graded
    quality
    A
    maintenance
    MCP server that connects to SQL databases (SQLite, PostgreSQL, MSSQL, MySQL) and provides tools to run read-only queries, list schemas/tables, and manage connections via stdio transport.
    Apache 2.0

View all related MCP servers

Related MCP Connectors

  • mcp

    MCP server for managing Prisma Postgres.

  • server

    An MCP server that let you interact with Cycloid.io Internal Development Portal and Platform

  • JFrog Remote MCP Server

    MCP Server for JFrog, providing tools for development and artifact management.

View all MCP Connectors

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/siimleetberg/mysql_connector_mcp'

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