{"id":43283,"library":"mysql-gui","title":"MySQL GUI","description":"A web-based graphical user interface for MySQL database management. Version 1.3.1 requires Node.js >=16.0.0 and npm >=8.0.0. Supports local and remote database connections, CRUD operations, multi-tab interface, query editor with autocompletion, pagination, AI integration (OpenAI, Google Gemini) for SQL generation, and optional basic authentication. Available as an npm global package, from source, or via Docker. Designed for developers needing a quick, browser-based MySQL client with AI-assisted query writing.","status":"active","version":"1.3.1","language":"javascript","source_language":"en","source_url":"https://github.com/kshashikumar/mysql-gui","tags":["javascript"],"install":[{"cmd":"npm install mysql-gui","lang":"bash","label":"npm"},{"cmd":"yarn add mysql-gui","lang":"bash","label":"yarn"},{"cmd":"pnpm add mysql-gui","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"MySQL driver for Node.js","package":"mysql","optional":false},{"reason":"Web framework for serving the GUI","package":"express","optional":false},{"reason":"Optional: used for AI integration if enabled","package":"openai","optional":true}],"imports":[{"note":"This package is a CLI tool, not a library. Do not import it in code.","wrong":"import mysqlGui from 'mysql-gui'","symbol":"default","correct":"npm install -g mysql-gui\n# then run: mysql-gui"}],"quickstart":{"code":"# Install globally\nnpm install -g mysql-gui\n\n# Run the application\nmysql-gui\n\n# For Docker:\ndocker run -d -p 5000:5000 --name mysql-gui -e \"MYSQL_URL=mysql://root:root@host.docker.internal:3306\" shashikumarkasturi/mysql-gui","lang":"javascript","description":"Quick start with MySQL GUI via npm global install or Docker."},"warnings":[{"fix":"Upgrade Node.js to version 16 or newer.","message":"Requires Node.js >=16.0.0 and npm >=8.0.0. Older versions will fail.","severity":"breaking","affected_versions":"<=1.3.1"},{"fix":"Use via command line or Docker.","message":"The package is a CLI tool. Do not import it as a module; it will not work.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Set AI_MODEL and AI_API_KEY in your environment or Docker compose file.","message":"AI integration uses environment variables (AI_MODEL, AI_API_KEY). If these are not set, AI features will fail silently.","severity":"gotcha","affected_versions":">=1.3.0"},{"fix":"Use the correct host (e.g., localhost or container network) for your OS.","message":"Default Docker image uses host.docker.internal for MySQL host. This only works on Docker for Windows/Mac, not Linux.","severity":"gotcha","affected_versions":">=1.0.0"}],"env_vars":null,"search_vec":"'1.3.1':15 '16.0.0':18 '8.0.0':21 'ai':39,75 'ai-assist':74 'assist':76 'authent':50 'autocomplet':37 'avail':51 'base':6,70 'basic':49 'browser':69 'browser-bas':68 'client':72 'connect':27 'crud':28 'databas':12,26 'design':62 'develop':64 'docker':61 'editor':35 'gemini':43 'generat':46 'global':55 'googl':42 'graphic':7 'gui':2 'integr':40 'interfac':9,33 'javascript':79 'local':23 'manag':13 'multi':31 'multi-tab':30 'mysql':1,11,71 'need':65 'node.js':17 'npm':20,54 'openai':41 'oper':29 'option':48 'packag':56 'pagin':38 'queri':34,77 'quick':67 'remot':25 'requir':16 'sourc':58 'sql':45 'support':22 'tab':32 'user':8 'version':14 'via':60 'web':5 'web-bas':4 'write':78","created_at":"2026-06-05T16:59:03.365473+00:00","updated_at":"2026-06-05T16:59:03.365473+00:00","problems":[{"fix":"Use the CLI command `mysql-gui` or run via Docker.","cause":"Trying to require/import the package in a Node.js script instead of using CLI.","error":"Error: Cannot find module 'mysql-gui'"},{"fix":"Kill the process using port 5000, or change the port with environment variable.","cause":"Port 5000 already in use by another process.","error":"Error: listen EADDRINUSE :::5000"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/kshashikumar/mysql-gui#readme","github":"https://github.com/kshashikumar/mysql-gui","docs":null,"changelog":null,"pypi":null,"npm":"mysql-gui","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}