{"name":"io.github.Rufflet/mysql-legacy-mcp","slug":"rufflet-mysql-legacy-mcp","title":"MySQL Legacy MCP","description":"Inspect and query MySQL 5.0–5.6; opt-in INSERT/UPDATE/DELETE/DDL. Live-verified 5.0–8.0.","url":"https://mcp.market/server/rufflet-mysql-legacy-mcp","rating":null,"grade":"B","score":83,"certified":false,"status":"active","category":"data","tags":["data"],"presence":{"score":30,"stars":0,"forks":0,"downloads_week":215,"last_push_at":"2026-09-15T20:53:42.000Z","license":"MIT"},"uptime":null,"claimed":false,"transport":"npm","callable_via_gateway":false,"default_price_micros":0,"repository":"https://github.com/Rufflet/mysql-legacy-mcp","website":"https://github.com/Rufflet/mysql-legacy-mcp","version":"0.2.1","remotes":[],"packages":[{"registryType":"npm","identifier":"mysql-legacy-mcp","version":"0.2.1","transport":{"type":"stdio"},"environmentVariables":[{"description":"Database host or local tunnel endpoint","isRequired":true,"name":"MYSQL_LEGACY_HOST"},{"description":"Dedicated database reader account","isRequired":true,"name":"MYSQL_LEGACY_USER"},{"description":"Nonempty database account password","isRequired":true,"isSecret":true,"name":"MYSQL_LEGACY_PASSWORD"},{"description":"TCP port, 1–65535","default":"3306","name":"MYSQL_LEGACY_PORT"},{"description":"Optional default database","name":"MYSQL_LEGACY_DATABASE"},{"description":"Hide mysql and information_schema from listings","default":"true","choices":["true","false"],"name":"MYSQL_LEGACY_HIDE_SYSTEM_DATABASES"},{"description":"Driver query timeout, 100–60000 milliseconds","default":"10000","name":"MYSQL_LEGACY_QUERY_TIMEOUT"},{"description":"SELECT response row limit, 1–1000","default":"200","name":"MYSQL_LEGACY_MAX_ROWS"},{"description":"SELECT row-data JSON byte limit, 1024–1048576","default":"262144","name":"MYSQL_LEGACY_MAX_RESULT_BYTES"},{"description":"Connection-establishment timeout, 100–60000 milliseconds","default":"10000","name":"MYSQL_LEGACY_CONNECT_TIMEOUT"},{"description":"Pooled connection limit, 1–50","default":"5","name":"MYSQL_LEGACY_POOL_SIZE"},{"description":"Enable the mysql_legacy_insert tool","default":"false","choices":["true","false"],"name":"MYSQL_LEGACY_ALLOW_INSERT"},{"description":"Enable the mysql_legacy_update tool (WHERE clause always required)","default":"false","choices":["true","false"],"name":"MYSQL_LEGACY_ALLOW_UPDATE"},{"description":"Enable the mysql_legacy_delete tool (WHERE clause always required)","default":"false","choices":["true","false"],"name":"MYSQL_LEGACY_ALLOW_DELETE"},{"description":"Enable the mysql_legacy_ddl tool (table-level statements only)","default":"false","choices":["true","false"],"name":"MYSQL_LEGACY_ALLOW_DDL"},{"description":"Disable the read-only transaction wrap around mysql_legacy_select on MySQL 5.6.5+","default":"false","choices":["true","false"],"name":"MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS"}]}],"tools":[{"name":"mysql_legacy_ddl","description":"Runs exactly one table-level CREATE, ALTER, DROP, TRUNCATE, or RENAME supplied in sql. Off unless MYSQL_LEGACY_ALLOW_DDL=true. DROP and TRUNCATE are irreversible. Rejects DROP DATABASE, views, and indexes. For row changes use mysql_legacy_insert, mysql_legacy_update, or mysql_legacy_delete.","write_action":true,"price_micros":0,"input_schema":null},{"name":"mysql_legacy_delete","description":"Runs exactly one DELETE supplied in sql. WHERE is required and cannot be disabled. Off unless MYSQL_LEGACY_ALLOW_DELETE=true. Returns affectedRows. To empty a table use TRUNCATE via mysql_legacy_ddl, not a WHERE-less DELETE.","write_action":true,"price_micros":0,"input_schema":null},{"name":"mysql_legacy_describe_table","description":"Lists columns for database.table via SHOW FULL COLUMNS, including type, nullability, keys, comments, and collation. Use this for per-column metadata. For the full CREATE TABLE text and default charset use mysql_legacy_show_create_table. For index column order use mysql_legacy_list_indexes.","write_action":false,"price_micros":0,"input_schema":null},{"name":"mysql_legacy_insert","description":"Runs exactly one INSERT supplied in sql. Off unless MYSQL_LEGACY_ALLOW_INSERT=true. Returns insertId and affectedRows. INSERT ... ON DUPLICATE KEY UPDATE is accepted and can overwrite existing rows. For UPDATE/DELETE/DDL use mysql_legacy_update, mysql_legacy_delete, or mysql_legacy_ddl.","write_action":true,"price_micros":0,"input_schema":null},{"name":"mysql_legacy_list_databases","description":"Lists database names via SHOW DATABASES. Hides mysql and information_schema unless include_system_databases=true (or MYSQL_LEGACY_HIDE_SYSTEM_DATABASES=false). Then pass a name to mysql_legacy_list_tables. Does not list tables or columns.","write_action":false,"price_micros":0,"input_schema":null},{"name":"mysql_legacy_list_indexes","description":"Lists indexes for database.table via SHOW INDEX (key name, columns, uniqueness, type). Use this for keys. For column types use mysql_legacy_describe_table; for full DDL use mysql_legacy_show_create_table.","write_action":false,"price_micros":0,"input_schema":null},{"name":"mysql_legacy_list_tables","description":"Lists base tables and views in one database via SHOW FULL TABLES FROM database. Pass database. For column types use mysql_legacy_describe_table; for CREATE TABLE text use mysql_legacy_show_create_table; for keys use mysql_legacy_list_indexes. To list databases first, use mysql_legacy_list_databases.","write_action":false,"price_micros":0,"input_schema":null},{"name":"mysql_legacy_ping","description":"Checks the MySQL connection with SELECT VERSION() AS version and returns {connected, version}. Call this first after connecting. For schema use mysql_legacy_list_tables; for row data use mysql_legacy_select.","write_action":false,"price_micros":0,"input_schema":null},{"name":"mysql_legacy_select","description":"Runs exactly one SELECT supplied in sql. Rejects SELECT INTO and locking reads; truncates by MYSQL_LEGACY_MAX_ROWS and MYSQL_LEGACY_MAX_RESULT_BYTES. On MySQL 5.6.5+ wraps in START TRANSACTION READ ONLY unless MYSQL_LEGACY_DISABLE_READ_ONLY_TRANSACTIONS=true. For columns use mysql_legacy_describe_table; for CREATE TABLE text use mysql_legacy_show_create_table; for writes use mysql_legacy_insert, m","write_action":true,"price_micros":0,"input_schema":null},{"name":"mysql_legacy_show_create_table","description":"Returns SHOW CREATE TABLE for database.table plus the parsed default charset. Use this for DDL text. For per-column types and collation use mysql_legacy_describe_table. For unique/non-unique keys use mysql_legacy_list_indexes.","write_action":true,"price_micros":0,"input_schema":null},{"name":"mysql_legacy_update","description":"Runs exactly one UPDATE supplied in sql. WHERE is required and cannot be disabled. Off unless MYSQL_LEGACY_ALLOW_UPDATE=true. Returns affectedRows and changedRows. To empty a table use TRUNCATE via mysql_legacy_ddl, not a WHERE-less UPDATE.","write_action":true,"price_micros":0,"input_schema":null}],"scan":{"score":83,"grade":"B","scanned_at":"2026-09-19T20:03:01.959Z","report":{"scannerVersion":"0.1.5","scannedAt":"2026-09-19T20:03:01.971Z","components":{"code":{"score":25,"max":25,"notes":["2 source files scanned"]},"reliability":{"score":-1,"max":20,"notes":["no gateway calls yet and no remote to probe"]},"poisoning":{"score":-1,"max":15,"notes":["tools not inspected (local package is not executed); not counted"]},"auth":{"score":6,"max":15,"notes":["static API keys via environment variables"]},"maintenance":{"score":15,"max":15,"notes":["last push 4 days ago"]},"identity":{"score":8,"max":10,"notes":["registry namespace matches repository owner","GitHub account older than a year"]}},"findings":[],"inputs":{"packages":[{"registryType":"npm","identifier":"mysql-legacy-mcp","version":"0.2.1","found":true,"license":"MIT","hasInstallScripts":false,"dependencyCount":4,"publishedAt":"2026-09-14T11:28:45.391Z","repositoryUrl":"git+https://github.com/Rufflet/mysql-legacy-mcp.git","weeklyDownloads":215}],"repo":{"found":true,"owner":"Rufflet","repo":"mysql-legacy-mcp","archived":false,"pushedAt":"2026-09-15T20:53:42Z","stars":0,"forks":0,"openIssues":0,"ownerType":"User","ownerAvatarUrl":"https://avatars.githubusercontent.com/u/15361093?v=4","ownerCreatedAt":"2015-10-28T11:59:04Z","license":"MIT"},"icon":{"url":"https://avatars.githubusercontent.com/u/15361093?v=4&s=128","source":"registry"},"presence":{"stars":0,"forks":0,"downloadsWeek":215,"license":"MIT","lastPushAt":"2026-09-15T20:53:42.000Z","score":30}}}},"grade_history":[],"reviews":[]}