{"id":42384,"library":"agent-mysql","title":"agent-mysql","description":"MySQL CLI tool designed for AI Agents, version 1.0.0. All commands output JSON for programmatic consumption. Each command opens a separate connection and closes immediately. Supports three connection methods: command-line flags, DSN string, and saved profiles via config file. Provides safety features requiring --force for destructive operations. Ideal for AI agents needing simple, repeatable MySQL access with predictable output.","status":"active","version":"1.0.0","language":"javascript","source_language":"en","source_url":null,"tags":["javascript","mysql","cli","agent","ai","database","typescript"],"install":[{"cmd":"npm install agent-mysql","lang":"bash","label":"npm"},{"cmd":"yarn add agent-mysql","lang":"bash","label":"yarn"},{"cmd":"pnpm add agent-mysql","lang":"bash","label":"pnpm"}],"dependencies":[],"imports":[],"quickstart":{"code":"agent-mysql -h localhost -P 3306 -u root -p mypassword -d mydb query \"SELECT * FROM users LIMIT 5\"","lang":"typescript","description":"Show how to run a query with full connection parameters each time."},"warnings":[{"fix":"Use `--dsn` with a DSN string or config set to store password in config file.","message":"Password provided via -p flag is visible in process list. Use --dsn or config profiles to avoid exposure.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Add .agent-mysql/config.json to .gitignore or use environment variables instead of config.","message":"Config file is stored in plain JSON in .agent-mysql/config.json. Avoid committing passwords to version control.","severity":"gotcha","affected_versions":">=1.0.0"},{"fix":"Specify --limit 0 or a higher number to get all rows.","message":"Default --limit 200 on SELECT queries may truncate results unknowingly.","severity":"gotcha","affected_versions":">=1.0.0"}],"env_vars":null,"search_vec":"'1.0.0':12 'access':61 'agent':2,10,56,68 'agent-mysql':1 'ai':9,55,69 'cli':5,67 'close':27 'command':14,21,34 'command-lin':33 'config':43 'connect':25,31 'consumpt':19 'databas':70 'design':7 'destruct':51 'dsn':37 'featur':47 'file':44 'flag':36 'forc':49 'ideal':53 'immedi':28 'javascript':65 'json':16 'line':35 'method':32 'mysql':3,4,60,66 'need':57 'open':22 'oper':52 'output':15,64 'predict':63 'profil':41 'programmat':18 'provid':45 'repeat':59 'requir':48 'safeti':46 'save':40 'separ':24 'simpl':58 'string':38 'support':29 'three':30 'tool':6 'typescript':71 'version':11 'via':42","created_at":"2026-06-05T16:54:44.282651+00:00","updated_at":"2026-06-05T16:54:44.282651+00:00","problems":[{"fix":"Run `npm install -g agent-mysql`","cause":"Package not installed globally.","error":"agent-mysql: command not found"},{"fix":"Verify password and ensure user has access from the connecting host.","cause":"Incorrect password or user permissions.","error":"Error: Connection failed: Access denied for user 'root'@'localhost'"},{"fix":"Add `--force` flag: `agent-mysql -h ... query \"DROP TABLE users\" --force`","cause":"Safety mechanism prevents destructive DDL without confirmation.","error":"Error: DROP/TRUNCATE/ALTER require --force flag"}],"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":null,"github":null,"docs":null,"changelog":null,"pypi":null,"npm":"agent-mysql","openapi_spec":null,"status_page":null,"smithery":null,"categories":["devops"],"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}}