[{"_1":2,"_304":-5,"_305":-5},"loaderData",{"_3":4,"_32":33,"_34":35,"_36":37,"_243":244},"root",{"_5":6,"_20":21},"toasts",[7,14,16,18],{"_8":9,"_10":11,"_12":13},"uid","d383a428-2bd4-4faf-b1fa-2c35d46ba727","title","This MCP server does not support inspection","type","error",{"_8":15,"_10":11,"_12":13},"47a05a8a-89fb-4662-9858-61591452c693",{"_8":17,"_10":11,"_12":13},"c6dbf52b-cd4c-4137-99d3-ba42d8f69e05",{"_8":19,"_10":11,"_12":13},"a4a7fa75-4f5b-4989-a1ed-ed52ca1e5f4b","visitor",{"_22":23,"_24":25},"viewportWidth",1280,"visitorSession",{"_26":27,"_29":-5,"_8":30,"_31":-5},"attributes",[28],"BOT","membership","gQn3JBbO2s","userAccount","routes/_public/_layout",{},"routes/_public/mcp/servers/~namespace/_layout",{},"routes/_public/mcp/servers/~namespace/~slug/_pages/_layout",{"_38":-5,"_39":40,"_41":42,"_162":163},"githubUser","maintainer",false,"mcpServer",{"_43":44,"_45":46,"_26":71,"_77":78,"_79":78,"_80":81,"_86":87,"_109":-5,"_110":111,"_112":40,"_113":114,"_96":132,"_133":101,"_134":-5,"_135":-5,"_136":-5,"_137":138,"_145":-5,"_146":147,"_152":-5,"_121":97,"_153":154,"_158":-5,"_8":159,"_160":161},"addedAt",["D",1742558185546],"argumentsJsonSchema",{"_47":48,"_68":69,"_12":70},"properties",{"_49":50,"_54":55,"_59":60,"_62":63,"_65":66},"MYSQL_HOST",{"_51":52,"_12":53},"description","Your MySQL host","string","MYSQL_PORT",{"_56":57,"_51":58,"_12":53},"default","3306","MySQL port","MYSQL_USER",{"_51":61,"_12":53},"Your MySQL username","MYSQL_DATABASE",{"_51":64,"_12":53},"Your database name","MYSQL_PASSWORD",{"_51":67,"_12":53},"Your MySQL password","required",[49,59,65,62],"object",[72,73,74,75,76],"author:claimed","category:databases","hosting:local-only","language:typescript","license_grade:a","descriptionMarkdown","A Model Context Protocol (MCP) server that enables AI assistants to interact with MySQL databases by executing SQL queries and checking database connectivity.","descriptionPlainText","githubProject",{"_82":83,"_84":85},"readme","# MCP MySQL App\n\nA Model Context Protocol (MCP) tools server implementation for interacting with MySQL databases through AI interfaces.\n\n## Overview\n\nThis project provides a set of tools that allow AI systems to connect to and query MySQL databases through the Model Context Protocol. It enables AI assistants to execute SQL queries and check database connectivity.\n\n## Features\n\n- Simple but powerful MySQL tool integration\n- Type-safe tool definitions\n- Enhanced error handling\n- Support for handling request abort signals\n- Session awareness\n\n## Installation\n\n1. Clone this repository\n2. Install dependencies:\n\n```bash\nnpm install\n```\n\n## How to Use the Tool\n\n### 1. Initial Setup\n\nClone this repository:\n```bash\ngit clone \ncd mcp-mysql-app\n```\n\nInstall dependencies:\n```bash\nnpm install\n```\n\nCreate a `.env` file in the root directory:\n```\nMYSQL_HOST=your_mysql_host\nMYSQL_USER=your_mysql_username\nMYSQL_PASSWORD=your_mysql_password\nMYSQL_DATABASE=your_database_name\nMYSQL_PORT=3306\n```\n\nBuild the project:\n```bash\nnpm run build\n```\n\nThe `dist` folder is now ready to be used for configuration in various AI platforms.\n\n### 2. Cursor Configuration\n\nFind your Cursor MCP configuration file:\n\n- Windows: `C:\\Users\\\\.cursor\\mcp.json`\n- macOS: `~/.cursor/mcp.json`\n- Linux: `~/.cursor/mcp.json`\n\nEdit the file to add the MySQL MCP server configuration:\n\n```json\n{\n \"mcpServers\": {\n \"mysql\": {\n \"command\": \"\",\n \"args\": [\n \"/dist/index.js\"\n ],\n \"env\": {\n \"MYSQL_HOST\": \"your_mysql_host\",\n \"MYSQL_USER\": \"your_mysql_username\",\n \"MYSQL_PASSWORD\": \"your_mysql_password\",\n \"MYSQL_DATABASE\": \"your_database_name\",\n \"MYSQL_PORT\": \"3306\"\n }\n }\n }\n}\n```\n\nReplace the placeholders:\n- ``: Path to your Node.js executable\n- ``: Absolute path to your MCP MySQL App project directory\n- MySQL environment variables with your actual database connection details\n\nExample configuration:\n\n```json\n{\n \"mcpServers\": {\n \"mysql\": {\n \"command\": \"C:\\\\nvm4w\\\\nodejs\\\\node.exe\",\n \"args\": [\n \"H:\\\\mcp\\\\my-mysql\\\\dist\\\\index.js\"\n ],\n \"env\": {\n \"MYSQL_HOST\": \"localhost\",\n \"MYSQL_USER\": \"root\",\n \"MYSQL_PASSWORD\": \"password123\",\n \"MYSQL_DATABASE\": \"todo_app\",\n \"MYSQL_PORT\": \"3306\"\n }\n }\n }\n}\n```\n\nSave the file and restart Cursor for the changes to take effect.\n\n### 3. Claude Configuration\n\nTo use MCP MySQL Tools with Claude, you need to add configuration to Claude's settings file. Follow these steps:\n\n1. Open Claude AI desktop app settings\n2. Navigate to the \"Developer\" section\n3. Look for the \"Tools\" configuration section\n4. Add configuration for MySQL MCP as follows:\n\n```json\n{\n \"tools\": {\n \"mysql\": {\n \"command\": \"\",\n \"args\": [\n \"/dist/index.js\"\n ],\n \"env\": {\n \"MYSQL_HOST\": \"your_mysql_host\",\n \"MYSQL_USER\": \"your_mysql_username\",\n \"MYSQL_PASSWORD\": \"your_mysql_password\",\n \"MYSQL_DATABASE\": \"your_database_name\",\n \"MYSQL_PORT\": \"3306\"\n }\n }\n }\n}\n```\n\nReplace the placeholders:\n- ``: Path to your Node.js executable\n- ``: Absolute path to your MCP MySQL App project directory\n- MySQL environment variables with your actual database connection details\n\nExample configuration:\n\n```json\n{\n \"tools\": {\n \"mysql\": {\n \"command\": \"/usr/local/bin/node\",\n \"args\": [\n \"/Users/username/projects/mcp-mysql-app/dist/index.js\"\n ],\n \"env\": {\n \"MYSQL_HOST\": \"localhost\",\n \"MYSQL_USER\": \"root\",\n \"MYSQL_PASSWORD\": \"password123\",\n \"MYSQL_DATABASE\": \"todo_app\",\n \"MYSQL_PORT\": \"3306\"\n }\n }\n }\n}\n```\n\n### 4. Configuration on Other Platforms\n\nThe basic principle is the same for other AI platforms that support MCP:\n\n1. Find the configuration area for external tools or MCP\n2. Configure it to run Node.js with the `dist/index.js` file from this repository\n3. Include your MySQL connection details in the environment configuration\n\n## Available Tools\n\nAfter configuration, your AI will have access to the following MySQL tools:\n\n- `sql_check_connection` - Check if the MySQL connection is working\n- `sql_query` - Execute SQL queries on the connected database\n\n## Using MySQL Tools in AI Environments\n\nOnce you've configured the MySQL tools in your AI environment, you can start using them by prompting the AI. Here are some examples:\n\n### Using MySQL Tools in Cursor\n\nIn Cursor, you can simply ask Claude to perform MySQL-related tasks:\n\n- Check if the MySQL connection is working.\n- Show me all databases on the server.\n- Get all tables from the current database.\n- Execute a query to retrieve all users from the users table.\n- Update a record in the products table.\n\n### Example Workflow: Querying and Manipulating Data\n\nHere's an example workflow showing how you might use these tools:\n\n1. Checking connection:\n \n \"Check if the MySQL connection is working.\"\n \n Claude will use the `sql_check_connection` tool to verify the database connection.\n\n2. Viewing databases:\n \n \"Show me all the databases on this MySQL server.\"\n \n Claude will use the `sql_query` tool with `SHOW DATABASES;`.\n\n3. Exploring tables:\n \n \"List all tables in the current database.\"\n \n Claude will use the `sql_query` tool with `SHOW TABLES;`.\n\n4. Querying data:\n \n \"Show me the first 10 records from the users table.\"\n \n Claude will use the `sql_query` tool with `SELECT * FROM users LIMIT 10;`.\n\n5. Creating tables:\n \n \"Create a new table named 'products' with columns for id, name, price, and description.\"\n \n Claude will use the `sql_query` tool to create the table with an appropriate CREATE TABLE statement.\n\n6. Inserting data:\n \n \"Insert a new product with the name 'Smartphone', price 499.99, and description 'Latest model'.\"\n \n Claude will use the `sql_query` tool with an INSERT statement.\n\n7. Updating records:\n \n \"Update the price of the 'Smartphone' product to 449.99.\"\n \n Claude will use the `sql_query` tool with an UPDATE statement.\n\nThese examples demonstrate how naturally you can interact with MySQL through your AI assistant once the tools are properly configured.\n\n## Support and Help\n\nIf you experience problems using this tool, please:\n\n- Check that your MySQL connection details are correct\n- Make sure Node.js is properly installed\n- Check your MCP configuration in your AI platform\n- Check log files for any error messages that might appear\n- Verify network connectivity to your MySQL server\n\n## License\n\nThis project is licensed under the MIT License - see the LICENSE file for details.","url","https://github.com/zalab-inc/mcp-mysql-app","githubRepository",{"_88":89,"_90":91,"_92":93,"_94":95,"_96":97,"_98":99,"_103":104,"_105":106,"_108":104},"defaultBranch","main","fullName","zalab-inc/mcp-mysql-app","githubTreeId",102712,"language","TypeScript","name","mcp-mysql-app","owner",{"_100":101,"_8":102},"login","zalab-inc","DhsPx3FUlW","recentStargazers",0,"spdxLicense",{"_96":107},"MIT License","stargazers","glamaJson","id",2550,"inspectable","integrations",[115,125],{"_116":117,"_51":123,"_8":124},"brand",{"_118":119,"_96":120,"_121":122},"logoSvgPath","M24 0v24H0V0h24ZM10.933 15.89H6.84v5.52h4.198v-.93H7.955v-1.503h2.77v-.93h-2.77v-1.224h2.978v-.934Zm2.146 0h-1.084v5.52h1.035v-3.6l2.226 3.6h1.118v-5.52h-1.036v3.686l-2.259-3.687Zm5.117 0h-1.208l1.973 5.52h1.19l1.976-5.52h-1.182l-1.352 4.085-1.397-4.086ZM5.4 19.68H3.72v1.68H5.4v-1.68Z",".ENV","slug","dotenv","Supports configuration of database connection details through environment variables in .env files","twk5mdp086",{"_116":126,"_51":130,"_8":131},{"_118":127,"_96":128,"_121":129},"M16.405 5.501c-.115 0-.193.014-.274.033v.013h.014c.054.104.146.18.214.273.054.107.1.214.154.32l.014-.015c.094-.066.14-.172.14-.333-.04-.047-.046-.094-.08-.14-.04-.067-.126-.1-.18-.153zM5.77 18.695h-.927a50.854 50.854 0 00-.27-4.41h-.008l-1.41 4.41H2.45l-1.4-4.41h-.01a72.892 72.892 0 00-.195 4.41H0c.055-1.966.192-3.81.41-5.53h1.15l1.335 4.064h.008l1.347-4.064h1.095c.242 2.015.384 3.86.428 5.53zm4.017-4.08c-.378 2.045-.876 3.533-1.492 4.46-.482.716-1.01 1.073-1.583 1.073-.153 0-.34-.046-.566-.138v-.494c.11.017.24.026.386.026.268 0 .483-.075.647-.222.197-.18.295-.382.295-.605 0-.155-.077-.47-.23-.944L6.23 14.615h.91l.727 2.36c.164.536.233.91.205 1.123.4-1.064.678-2.227.835-3.483zm12.325 4.08h-2.63v-5.53h.885v4.85h1.745zm-3.32.135l-1.016-.5c.09-.076.177-.158.255-.25.433-.506.648-1.258.648-2.253 0-1.83-.718-2.746-2.155-2.746-.704 0-1.254.232-1.65.697-.43.508-.646 1.256-.646 2.245 0 .972.19 1.686.574 2.14.35.41.877.615 1.583.615.264 0 .506-.033.725-.098l1.325.772.36-.622zM15.5 17.588c-.225-.36-.337-.94-.337-1.736 0-1.393.424-2.09 1.27-2.09.443 0 .77.167.977.5.224.362.336.936.336 1.723 0 1.404-.424 2.108-1.27 2.108-.445 0-.77-.167-.978-.5zm-1.658-.425c0 .47-.172.856-.516 1.156-.344.3-.803.45-1.384.45-.543 0-1.064-.172-1.573-.515l.237-.476c.438.22.833.328 1.19.328.332 0 .593-.073.783-.22a.754.754 0 00.3-.615c0-.33-.23-.61-.648-.845-.388-.213-1.163-.657-1.163-.657-.422-.307-.632-.636-.632-1.177 0-.45.157-.81.47-1.085.315-.278.72-.415 1.22-.415.512 0 .98.136 1.4.41l-.213.476a2.726 2.726 0 00-1.064-.23c-.283 0-.502.068-.654.206a.685.685 0 00-.248.524c0 .328.234.61.666.85.393.215 1.187.67 1.187.67.433.305.648.63.648 1.168zm9.382-5.852c-.535-.014-.95.04-1.297.188-.1.04-.26.04-.274.167.055.053.063.14.11.214.08.134.218.313.346.407.14.11.28.216.427.31.26.16.555.255.81.416.145.094.293.213.44.313.073.05.12.14.214.172v-.02c-.046-.06-.06-.147-.105-.214-.067-.067-.134-.127-.2-.193a3.223 3.223 0 00-.695-.675c-.214-.146-.682-.35-.77-.595l-.013-.014c.146-.013.32-.066.46-.106.227-.06.435-.047.67-.106.106-.027.213-.06.32-.094v-.06c-.12-.12-.21-.283-.334-.395a8.867 8.867 0 00-1.104-.823c-.21-.134-.476-.22-.697-.334-.08-.04-.214-.06-.26-.127-.12-.146-.19-.34-.275-.514a17.69 17.69 0 01-.547-1.163c-.12-.262-.193-.523-.34-.763-.69-1.137-1.437-1.826-2.586-2.5-.247-.14-.543-.2-.856-.274-.167-.008-.334-.02-.5-.027-.11-.047-.216-.174-.31-.235-.38-.24-1.364-.76-1.644-.072-.18.434.267.862.422 1.082.115.153.26.328.34.5.047.116.06.235.107.356.106.294.207.622.347.897.073.14.153.287.247.413.054.073.146.107.167.227-.094.136-.1.334-.154.5-.24.757-.146 1.693.194 2.25.107.166.362.534.703.393.3-.12.234-.5.32-.835.02-.08.007-.133.048-.187v.015c.094.188.188.367.274.555.206.328.566.668.867.895.16.12.287.328.487.402v-.02h-.015c-.043-.058-.1-.086-.154-.133a3.445 3.445 0 01-.35-.4 8.76 8.76 0 01-.747-1.218c-.11-.21-.202-.436-.29-.643-.04-.08-.04-.2-.107-.24-.1.146-.247.273-.32.453-.127.288-.14.642-.188 1.01-.027.007-.014 0-.027.014-.214-.052-.287-.274-.367-.46-.2-.475-.233-1.238-.06-1.785.047-.14.247-.582.167-.716-.042-.127-.174-.2-.247-.303a2.478 2.478 0 01-.24-.427c-.16-.374-.24-.788-.414-1.162-.08-.173-.22-.354-.334-.513-.127-.18-.267-.307-.368-.52-.033-.073-.08-.194-.027-.274.014-.054.042-.075.094-.09.088-.072.335.022.422.062.247.1.455.194.662.334.094.066.195.193.315.226h.14c.214.047.455.014.655.073.355.114.675.28.962.46a5.953 5.953 0 012.085 2.286c.08.154.115.295.188.455.14.33.313.663.455.982.14.315.275.636.476.897.1.14.502.213.682.286.133.06.34.115.46.188.23.14.454.3.67.454.11.076.443.243.463.378z","MySQL","mysql","Enables AI assistants to interact with MySQL databases by executing SQL queries and checking database connectivity","m65w2bfbac","MCP MySQL App","namespace","npmPackage","prompts","redditPostForeignId","relatedMcpServerIds",[139,140,141,142,143,144],1861,1113,1673,254,319,1887,"resources","scores",{"_148":149,"_150":-5,"_151":-5},"license",100,"quality","security","simpleIcon","supportedPlatforms",[155,156,157],"WINDOWS","MACOS","LINUX","tools","g85jbuf1l4","updatedAt",["D",1742774713428],"meta",[164,166,168,175,178,180,183,186,189,192,195,197,200,203,205,207,209,211,213],{"_10":165},"MCP MySQL App | Glama",{"_167":78,"_96":51},"content",{"_169":170,"_171":172,"_173":174},"href","https://glama.ai/mcp/servers/@zalab-inc/mcp-mysql-app","rel","canonical","tagName","link",{"_167":132,"_176":177},"property","og:title",{"_167":78,"_176":179},"og:description",{"_167":181,"_176":182},"https://glama.ai/logo.png","og:logo",{"_167":184,"_176":185},"https://glama.ai/mcp/servers/@zalab-inc/mcp-mysql-app/og-image","og:image",{"_167":187,"_176":188},"630","og:image:height",{"_167":190,"_176":191},"1200","og:image:width",{"_167":193,"_176":194},"website","og:type",{"_167":170,"_176":196},"og:url",{"_167":198,"_176":199},"ChatGPT alternative for power users","og:site_name",{"_167":201,"_96":202},"summary_large_image","twitter:card",{"_167":198,"_96":204},"twitter:title",{"_167":78,"_96":206},"twitter:description",{"_167":184,"_96":208},"twitter:image",{"_167":187,"_96":210},"twitter:image:height",{"_167":190,"_96":212},"twitter:image:width",{"_214":215},"script:ld+json",{"_216":217,"_218":219},"@context","http://schema.org","@graph",[220],{"_216":221,"_222":223,"_224":225},"https://schema.org","@type","BreadcrumbList","itemListElement",[226,233,237,241],{"_222":227,"_228":229,"_96":230,"_231":232},"ListItem","item","https://glama.ai/","Glama","position",1,{"_222":227,"_228":234,"_96":235,"_231":236},"https://glama.ai/mcp","MCP",2,{"_222":227,"_228":238,"_96":239,"_231":240},"https://glama.ai/mcp/servers","Servers",3,{"_222":227,"_228":170,"_96":132,"_231":242},4,"routes/_public/mcp/servers/~namespace/~slug/_pages/reviews/_route",{"_38":-5,"_41":245,"_162":269,"_303":-5},{"_43":246,"_45":247,"_26":255,"_77":78,"_79":78,"_80":256,"_86":257,"_109":-5,"_110":111,"_112":40,"_113":260,"_96":132,"_133":101,"_134":-5,"_135":-5,"_136":-5,"_137":265,"_145":-5,"_146":266,"_152":-5,"_121":97,"_153":267,"_158":-5,"_8":159,"_160":268},["D",1742558185546],{"_47":248,"_68":254,"_12":70},{"_49":249,"_54":250,"_59":251,"_62":252,"_65":253},{"_51":52,"_12":53},{"_56":57,"_51":58,"_12":53},{"_51":61,"_12":53},{"_51":64,"_12":53},{"_51":67,"_12":53},[49,59,65,62],[72,73,74,75,76],{"_82":83,"_84":85},{"_88":89,"_90":91,"_92":93,"_94":95,"_96":97,"_98":258,"_103":104,"_105":259,"_108":104},{"_100":101,"_8":102},{"_96":107},[261,263],{"_116":262,"_51":123,"_8":124},{"_118":119,"_96":120,"_121":122},{"_116":264,"_51":130,"_8":131},{"_118":127,"_96":128,"_121":129},[139,140,141,142,143,144],{"_148":149,"_150":-5,"_151":-5},[155,156,157],["D",1742774713428],[270,272,273,275,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291],{"_10":271},"Reviews | MCP MySQL App | Glama",{"_167":78,"_96":51},{"_169":274,"_171":172,"_173":174},"https://glama.ai/mcp/servers/@zalab-inc/mcp-mysql-app/reviews",{"_167":276,"_176":177},"Reviews | MCP MySQL App",{"_167":78,"_176":179},{"_167":181,"_176":182},{"_167":184,"_176":185},{"_167":187,"_176":188},{"_167":190,"_176":191},{"_167":193,"_176":194},{"_167":274,"_176":196},{"_167":198,"_176":199},{"_167":201,"_96":202},{"_167":198,"_96":204},{"_167":78,"_96":206},{"_167":184,"_96":208},{"_167":187,"_96":210},{"_167":190,"_96":212},{"_214":292},{"_216":217,"_218":293},[294],{"_216":221,"_222":223,"_224":295},[296,297,298,299,300],{"_222":227,"_228":229,"_96":230,"_231":232},{"_222":227,"_228":234,"_96":235,"_231":236},{"_222":227,"_228":238,"_96":239,"_231":240},{"_222":227,"_228":170,"_96":132,"_231":242},{"_222":227,"_228":274,"_96":301,"_231":302},"Reviews",5,"review","actionData","errors"]

Rate & Review