MCP server intelligence profile

MCP-MySQL Server MCP Server

Enables AI models to perform MySQL database operations through a standardized interface, supporting secure connections, query execution, and comprehensive schema management

Local Onlyenemyrr

1Distribution channel

14Independently observed tools

0Linked remote endpoints

AvailableVersion intelligence

Detailed security scan evidence is not public for this MCP yet. Public identity, registry metadata, and independently observed protocol inventory remain available.

Install and connect

Installation and connection instructions are shown only when supported by retained package, repository, or endpoint evidence.

Install mcp-mysql-server from npm

Version 0.2.0 declares 1 executable entrypoint.

npm install --save-exact mcp-mysql-server@0.2.0

npx -y -p mcp-mysql-server@0.2.0 mcp-mysql-server

MCP client configuration example

{
  "mcpServers": {
    "mcp-mysql-server": {
      "command": "npx",
      "args": [
        "-y",
        "-p",
        "mcp-mysql-server@0.2.0",
        "mcp-mysql-server"
      ]
    }
  }
}

Identity

Canonical slug	`mcp-mysql-server-27a49093`	Deployment	Local Only
Canonical package	npm:mcp-mysql-server	Repository	enemyrr/mcp-mysql-server
First published	—	Latest release	—
Last security verification	—	Classification confidence	90%
Publication	Draft	Official distribution	Not verified

Distributions

Channel	Identifier	Current version	Versions	Source
npm	mcp-mysql-server	`0.2.0`	7	Repository

Current release

Package	Version	Published / observed	Inventory	Security scan
npmmcp-mysql-server	`0.2.0`Current	Sep 5, 2026	14 toolsSucceeded · 0 resources · 5 prompts	Evidence restricted

Enterprise protection

Continuously monitor this MCP for security risk

Independently scan the exact version your agents use, receive alerts when its risk changes, and investigate every finding with retained version evidence.

Independent exact-version security scans
Continuous release and vulnerability monitoring
Risk-change alerts with capability context
Historical evidence and API exports

Custom pricingContact salesTailored to your organization, integrations, data needs, and support requirements.

Current version evidence

No public current-version evidence is available yet.

Current protocol inventory

2025-06-18Negotiated protocol

mysql-serverServer-reported name

3Capability groups

Aug 15, 2026Observed

Tools 14

Tool	Category	Risk
add_columnAdd a new column to an existing table Input schema { "type": "object", "properties": { "table": { "type": "string", "description": "Table name" }, "field": { "type": "object", "properties": { "name": { "type": "string", "description": "Column name" }, "type": { "type": "string", "description": "MySQL column type" }, "length": { "type": "number", "description": "Column length" }, "nullable": { "type": "boolean", "description": "Allow NULL values" }, "default": { "type": [ "string", "number", "null" ], "description": "Default value" } }, "required": [ "name", "type" ], "description": "Column definition" } }, "required": [ "table", "field" ] }	—	—
alter_columnModify an existing column (type, nullable, default, or rename) Input schema { "type": "object", "properties": { "table": { "type": "string", "description": "Table name" }, "column": { "type": "string", "description": "Column name to modify" }, "type": { "type": "string", "description": "New column type" }, "length": { "type": "number", "description": "New column length" }, "nullable": { "type": "boolean", "description": "Allow NULL values" }, "default": { "type": [ "string", "number", "null" ], "description": "New default value" }, "newName": { "type": "string", "description": "New column name (for renaming)" } }, "required": [ "table", "column" ] }	—	—
connect_dbConnect to a MySQL database using URL, workspace config, or direct parameters Input schema { "type": "object", "properties": { "url": { "type": "string", "description": "Database URL (mysql://user:pass@host:port/db)" }, "workspace": { "type": "string", "description": "Project workspace path containing .env file" }, "host": { "type": "string", "description": "Database host" }, "port": { "type": "number", "description": "Database port (default: 3306)" }, "user": { "type": "string", "description": "Database user" }, "password": { "type": "string", "description": "Database password" }, "database": { "type": "string", "description": "Database name" } } }	—	—
create_tableCreate a new table with specified columns and indexes Input schema { "type": "object", "properties": { "table": { "type": "string", "description": "Table name" }, "fields": { "type": "array", "items": { "type": "object", "properties": { "name": { "type": "string", "description": "Column name" }, "type": { "type": "string", "description": "MySQL column type" }, "length": { "type": "number", "description": "Column length" }, "nullable": { "type": "boolean", "description": "Allow NULL values" }, "default": { "type": [ "string", "number", "null" ], "description": "Default value" }, "autoIncrement": { "type": "boolean", "description": "Auto-increment" }, "primary": { "type": "boolean", "description": "Primary key" } }, "required": [ "name", "type" ] }, "description": "Column definitions" }, "indexes": { "type": "array", "items": { "type": "object", "properties": { "name": { "type": "string", "description": "Index name" }, "columns": { "type": "array", "items": { "type": "string" }, "description": "Indexed columns" }, "unique": { "type": "boolean", "description": "Unique index" } }, "required": [ "name", "columns" ] }, "description": "Index definitions" } }, "required": [ "table", "fields" ] }	—	—
describe_tableGet detailed structure of a table including columns, types, and constraints Input schema { "type": "object", "properties": { "table": { "type": "string", "description": "Table name" } }, "required": [ "table" ] }	—	—
drop_columnRemove a column from a table Input schema { "type": "object", "properties": { "table": { "type": "string", "description": "Table name" }, "column": { "type": "string", "description": "Column name to drop" } }, "required": [ "table", "column" ] }	—	—
drop_tableDelete a table (requires confirmation) Input schema { "type": "object", "properties": { "table": { "type": "string", "description": "Table name" }, "confirm": { "type": "boolean", "description": "Set to true to confirm deletion" } }, "required": [ "table", "confirm" ] }	—	—
executeExecute an INSERT, UPDATE, or DELETE query Input schema { "type": "object", "properties": { "sql": { "type": "string", "description": "The SQL query (INSERT, UPDATE, DELETE) to execute" }, "params": { "type": "array", "items": { "type": [ "string", "number", "boolean", "null" ] }, "description": "Optional parameters to bind to query placeholders (?)" } }, "required": [ "sql" ] }	—	—
get_foreign_keysList all foreign key relationships for a table Input schema { "type": "object", "properties": { "table": { "type": "string", "description": "Table name" } }, "required": [ "table" ] }	—	—
get_indexesList all indexes on a table Input schema { "type": "object", "properties": { "table": { "type": "string", "description": "Table name" } }, "required": [ "table" ] }	—	—
list_databasesList all accessible databases on the server Input schema { "type": "object", "properties": {} }	—	—
list_tablesList all tables in the connected database Input schema { "type": "object", "properties": {} }	—	—
queryExecute a SELECT query and return results Input schema { "type": "object", "properties": { "sql": { "type": "string", "description": "The SQL SELECT query to execute" }, "params": { "type": "array", "items": { "type": [ "string", "number", "boolean", "null" ] }, "description": "Optional parameters to bind to query placeholders (?)" } }, "required": [ "sql" ] }	—	—
truncate_tableRemove all rows from a table (requires confirmation) Input schema { "type": "object", "properties": { "table": { "type": "string", "description": "Table name" }, "confirm": { "type": "boolean", "description": "Set to true to confirm truncation" } }, "required": [ "table", "confirm" ] }	—	—

Resources 0

None observed.

Resource templates 4

Table Columnsmysql://tables/{table}/columns
Get column definitions for a specific table
Table Detailsmysql://tables/{table}
Get detailed information about a specific table
Table Indexesmysql://tables/{table}/indexes
Get index information for a specific table
Table Sample Datamysql://tables/{table}/sample
Get sample rows from a specific table (limit 5)

Prompts 5

explain-schemaexplain-schema
Get a natural language explanation of a table structure
generate-insertgenerate-insert
Generate an INSERT statement template for a table
generate-selectgenerate-select
Generate a SELECT query for a table with optional filters
generate-updategenerate-update
Generate an UPDATE statement template for a table
suggest-indexessuggest-indexes
Analyze a table and suggest potential indexes for optimization

Remote endpoints

Endpoint	Transport	Authentication	Health	Observed
No verified remote endpoint is linked.

MCP-MySQL Server MCP Server questions

How do I install MCP-MySQL Server MCP Server?

Install the selected package version with: npm install --save-exact mcp-mysql-server@0.2.0

What tools does MCP-MySQL Server MCP Server provide?

MCP-MySQL Server MCP Server exposed 14 tools during independent protocol observation, including add_column, alter_column, connect_db, create_table, describe_table, drop_column, drop_table, execute, and others.

Is MCP-MySQL Server MCP Server secure?

The selected current version does not yet have completed public verification. Unknown does not mean clean or vulnerable.

Explore related MCP server guides

Curated product and capability guides containing this catalog record.

Database MCP Servers Official vs Community MCP Servers