Claude Desktop
Desktop · Freemium · Proprietary
Anthropic's official Claude AI desktop application. Supports MCP servers to extend functionality.
WindowsMacOS
MySQL Database Server Nnk
enemyrr/mcp-mysql-server
A Model Context Protocol server that provides MySQL database operations. This server enables AI models to interact with MySQL databases through a standardized interface.
Install
npx -y @smithery/cli install @enemyrr/mcp-mysql-server --client claudeEnvironment variables
DATABASE_URLDB_HOSTDB_USERDB_PASSWORDDB_DATABASE- GitHub stars
- 22
- Author
- @enemyrr
- Category
- Database, Developer Tools
- License
- MIT
- Updated
- Oct 6, 2026
Features
14 database tools for queries, schema management, and more
MCP Resources for browsing database schema
MCP Prompts for generating SQL queries
Multiple connection methods (URL, workspace, direct)
Secure connection handling with automatic cleanup
Prepared statement support for query parameters
Comprehensive error handling and validation
TypeScript support
Tools (12)
connect_db
Connect to MySQL database using URL, workspace path, or direct credentials.
list_tables
List all tables in the connected database.
describe_table
Get the structure of a specific table.
create_table
Create a new table with specified fields and indexes.
add_column
Add a new column to an existing table.
alter_column
Modify an existing column (type, nullable, default, or rename).
drop_column
Remove a column from a table.
drop_table
Delete a table (requires confirmation).
truncate_table
Remove all rows from a table (requires confirmation).
list_databases
List all accessible databases on the server.
get_indexes
List all indexes on a table.
get_foreign_keys
List all foreign key relationships for a table.
Details on this page are taken from the project's README. Open README
Supported clients
Clients mentioned in this server's README:
Related MCP servers
Supabase MCP
supabase-community/supabase-mcp
The Model Context Protocol (MCP) standardizes how Large Language Models (LLMs) talk to external services like Supabase. It connects AI assistants directly with your Supabase project and allows them to perform tasks like managing tables, fetching config, and querying data. See the full list of tools.
Genai Toolbox
googleapis/genai-toolbox
MCP Toolbox for Databases is an open source Model Context Protocol (MCP) server that connects your AI agents, IDEs, and applications directly to your enterprise databases.
Supabase MCP Server
alexander-zuev/supabase-mcp-server
Query MCP is an open-source MCP server that lets your IDE safely run SQL, manage schema changes, call the Supabase Management API, and use Auth Admin SDK — all with built-in safety controls.
Awesome MCP List
MobinX/awesome-mcp-list
This is a continuously updated curated list of MCP servers, covering categories such as browser control, arts and culture, cloud platforms, command line, communication, customer data platforms, databases, developer tools, data science tools, file systems, finance and fintech, gaming, knowledge and memory, location services, marketing, monitoring, search and utilities. Each project includes a GitHub link and star count for quick reference and use.
PostgreSQL Model Context Protocol (PG MCP) Server
stuzero/pg-mcp-server
PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture.
dbhub
bytebase/dbhub
[!NOTE] If you need an enterprise-level database MCP server with built-in guardrails like approval flow, access control, data masking, and audit logging beyond what DBHub offers, check out Bytebase.