MySQL (read-only, switchable)
io.github.shibbirweb/mcp-mysql-read-only ยท version 1.1.6
Community listing. Not installed or verified by cosmic-mcp. Read the source and its permissions before you run it.
Read-only MySQL access, with the database and server switchable mid-conversation.
https://github.com/shibbirweb/mcp-mysql-read-onlyQuick facts
- Listing: Community
- Published Sep 24, 07:10 UTC
- Transport: stdio
- Package: npm
@shibbirweb/mcp-mysql-read-only1.1.6 - Listed by cosmic-mcp: Nov 9, 04:27 UTC
Details
- Repository: https://github.com/shibbirweb/mcp-mysql-read-only
- npm: https://www.npmjs.com/package/@shibbirweb/mcp-mysql-read-only
- Website: https://github.com/shibbirweb/mcp-mysql-read-only
- Needs settings:
MYSQL_HOSTMYSQL_PORTMYSQL_USERMYSQL_PASSWORDMYSQL_DATABASEMYSQL_PROFILESMYSQL_DEFAULT_PROFILEMYSQL_CONNECT_TIMEOUT_MSMYSQL_QUERY_TIMEOUT_MS
Setup snippets
Generated from the registry entry. cosmic-mcp has not run or reviewed this server; values in angle brackets are yours to fill in.
Run it locally (npm)
npx -y '@shibbirweb/[email protected]'Claude Desktop (claude_desktop_config.json)
{
"mcpServers": {
"mcp-mysql-read-only": {
"args": [
"-y",
"@shibbirweb/[email protected]"
],
"command": "npx",
"env": {
"MYSQL_CONNECT_TIMEOUT_MS": "<your mysql connect timeout ms>",
"MYSQL_DATABASE": "<your mysql database>",
"MYSQL_DEFAULT_PROFILE": "<your mysql default profile>",
"MYSQL_HOST": "<your mysql host>",
"MYSQL_PASSWORD": "<your mysql password>",
"MYSQL_PORT": "<your mysql port>",
"MYSQL_PROFILES": "<your mysql profiles>",
"MYSQL_QUERY_TIMEOUT_MS": "<your mysql query timeout ms>",
"MYSQL_USER": "<your mysql user>"
}
}
}
}Claude Code
claude mcp add 'mcp-mysql-read-only' -- npx -y '@shibbirweb/[email protected]'Cursor (.cursor/mcp.json)
{
"mcpServers": {
"mcp-mysql-read-only": {
"args": [
"-y",
"@shibbirweb/[email protected]"
],
"command": "npx",
"env": {
"MYSQL_CONNECT_TIMEOUT_MS": "<your mysql connect timeout ms>",
"MYSQL_DATABASE": "<your mysql database>",
"MYSQL_DEFAULT_PROFILE": "<your mysql default profile>",
"MYSQL_HOST": "<your mysql host>",
"MYSQL_PASSWORD": "<your mysql password>",
"MYSQL_PORT": "<your mysql port>",
"MYSQL_PROFILES": "<your mysql profiles>",
"MYSQL_QUERY_TIMEOUT_MS": "<your mysql query timeout ms>",
"MYSQL_USER": "<your mysql user>"
}
}
}
}VS Code (.vscode/mcp.json)
{
"servers": {
"mcp-mysql-read-only": {
"args": [
"-y",
"@shibbirweb/[email protected]"
],
"command": "npx",
"env": {
"MYSQL_CONNECT_TIMEOUT_MS": "<your mysql connect timeout ms>",
"MYSQL_DATABASE": "<your mysql database>",
"MYSQL_DEFAULT_PROFILE": "<your mysql default profile>",
"MYSQL_HOST": "<your mysql host>",
"MYSQL_PASSWORD": "<your mysql password>",
"MYSQL_PORT": "<your mysql port>",
"MYSQL_PROFILES": "<your mysql profiles>",
"MYSQL_QUERY_TIMEOUT_MS": "<your mysql query timeout ms>",
"MYSQL_USER": "<your mysql user>"
},
"type": "stdio"
}
}
}Related servers
- spotdb Verified domain
Ephemeral data sandbox for AI workflows with guardrails and security - Reasonbook Verified domain
Reasonbook: decisions that survive the session, in a local record AI agents keep. - AI for Database Verified domain
Ask your databases questions in plain English, run read-only SQL and set up data alerts. - AI2SQL Verified domain
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema - AICasePredict Verified domain
Search a large legal database of 325M+ US court records: cases, attorneys, judges and courts. - APC Security Reference Server
Reference MCP server for synthetic APC action-security evaluation and local SQLite sandbox testin...