@apono-io/mcp-mysql
v0.1.1
Published
Apono MCP server for MySQL databases with JIT credential support
Downloads
125
Readme
@apono-io/mcp-mysql
Apono MCP server for MySQL databases with JIT credential support.
Tools
| Tool | Description |
|------|------------|
| query | Execute a read-only SQL SELECT query and return results |
| execute | Execute a SQL statement that modifies data (INSERT, UPDATE, DELETE) |
| list_databases | List all databases on the server |
| list_tables | List all tables in a database |
| describe_table | Get column names, types, constraints, and indexes for a table |
| get_table_indexes | List indexes on a specific table |
| explain_query | Get the execution plan for a SQL query |
All tools (except list_databases) accept a database parameter.
Environment Variables
| Variable | Description |
|----------|------------|
| MYSQL_HOST | MySQL server hostname |
| MYSQL_PORT | MySQL server port (default: 3306) |
| MYSQL_USER | Database username |
| MYSQL_PASSWORD | Database password |
