PHPackages coquibot/coqui-toolkit-mysql-admin - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. coquibot/coqui-toolkit-mysql-admin ActiveLibrary[Database & ORM](/categories/database) coquibot/coqui-toolkit-mysql-admin ================================== MySQL database administration toolkit for Coqui — connect, query, manage schemas, backup/restore, optimize, user management, and NiFi pipeline template generation for MySQL databases v0.1.1(2mo ago)00MITPHPPHP ^8.4 Since Apr 9Pushed 2mo agoCompare [ Source](https://github.com/carmelosantana/coqui-toolkit-mysql-admin)[ Packagist](https://packagist.org/packages/coquibot/coqui-toolkit-mysql-admin)[ RSS](/packages/coquibot-coqui-toolkit-mysql-admin/feed)WikiDiscussions main Synced 1w ago READMEChangelogDependencies (3)Versions (3)Used By (0) MySQL Admin Toolkit for Coqui ============================= [](#mysql-admin-toolkit-for-coqui) A comprehensive MySQL database administration toolkit for [Coqui](https://github.com/carmelosantana/coqui). Provides 13 agent-facing tools for connecting, querying, schema management, backup, performance analysis, user management, and NiFi pipeline integration. Installation ------------ [](#installation) ``` composer require coquibot/coqui-toolkit-mysql-admin ``` The toolkit is auto-discovered by Coqui on startup via the `extra.php-agents.toolkits` declaration in `composer.json`. Requirements ------------ [](#requirements) - PHP 8.4+ - `ext-pdo_mysql` - `carmelosantana/php-agents` ^0.7 ### Optional [](#optional) - `doctrine/dbal` ^4.4 — Enhanced schema introspection - `carmelosantana/php-nifi-pipelines` ^0.1 — NiFi pipeline generation Credentials ----------- [](#credentials) The toolkit declares MySQL credentials via the Coqui credential system. Set them with: ``` credentials(action: "set", key: "MYSQL_HOST", value: "localhost") credentials(action: "set", key: "MYSQL_USER", value: "root") credentials(action: "set", key: "MYSQL_PASSWORD", value: "secret") credentials(action: "set", key: "MYSQL_DATABASE", value: "mydb") ``` CredentialRequiredDescription`MYSQL_HOST`YesMySQL server hostname`MYSQL_USER`YesMySQL username`MYSQL_PASSWORD`YesMySQL password`MYSQL_PORT`NoPort (default: 3306)`MYSQL_DATABASE`NoDefault databaseTools ----- [](#tools) ToolDescription`mysql_connect`Connect to a MySQL server`mysql_disconnect`Disconnect from a MySQL server`mysql_connections`List all open connections`mysql_query`Execute SQL queries with parameterized inputs`mysql_schema`Inspect databases, tables, indexes, views, routines, triggers`mysql_schema_modify`DDL operations: create/alter/drop tables, indexes, views, databases`mysql_transaction`Transaction management with savepoints`mysql_import_export`Import/export CSV, JSON; SQL dump via mysqldump`mysql_backup_restore`Backup, restore, and clone databases`mysql_optimize`OPTIMIZE, ANALYZE, CHECK, REPAIR tables; InnoDB status`mysql_analyze`EXPLAIN queries, index suggestions, slow query analysis`mysql_user`User and privilege management (CREATE/DROP USER, GRANT, REVOKE)`mysql_nifi_template`Generate NiFi pipeline templates for MySQL workflowsGated Operations ---------------- [](#gated-operations) Destructive operations require user confirmation (unless `--auto-approve` is enabled): - `mysql_schema_modify`: drop\_table, drop\_database, drop\_view, drop\_index - `mysql_backup_restore`: restore, clone - `mysql_query`: write operations - `mysql_user`: create, drop, grant, revoke, set\_password - `mysql_optimize`: repair, flush Usage Examples -------------- [](#usage-examples) ### Connect and Query [](#connect-and-query) ``` mysql_connect(host: "localhost", user: "root", password: "secret", database: "mydb") mysql_query(sql: "SELECT * FROM users WHERE active = ?", params: '[1]') ``` ### Schema Operations [](#schema-operations) ``` mysql_schema(action: "tables") mysql_schema(action: "describe", table: "users") mysql_schema_modify(action: "create_table", table: "logs", columns: '[{"name": "id", "type": "INT", "pk": true, "auto_increment": true}, {"name": "message", "type": "TEXT"}]') ``` ### Performance Analysis [](#performance-analysis) ``` mysql_analyze(action: "explain", sql: "SELECT * FROM orders WHERE customer_id = 42") mysql_analyze(action: "index_suggestions", table: "orders") mysql_analyze(action: "slow_queries") ``` ### Backup and Restore [](#backup-and-restore) ``` mysql_backup_restore(action: "backup", destination: "mydb_2024.sql") mysql_backup_restore(action: "restore", destination: "mydb_2024.sql") mysql_backup_restore(action: "clone", destination: "mydb_staging") ``` ### User Management [](#user-management) ``` mysql_user(action: "list") mysql_user(action: "create", user: "app_user", password: "secure_pass") mysql_user(action: "grant", user: "app_user", privileges: "SELECT,INSERT,UPDATE", on_database: "mydb.*") ``` ### NiFi Integration [](#nifi-integration) ``` mysql_nifi_template(action: "etl_ingest", source_type: "sftp", table: "orders") mysql_nifi_template(action: "data_export", dest_type: "csv", table: "reports") mysql_nifi_template(action: "cdc_pipeline", table: "orders") ``` Deploy the generated JSON: ``` nifi_pipeline(action: "deploy", definition: '') ``` Architecture ------------ [](#architecture) ``` src/ ├── MysqlAdminToolkit.php # Main ToolkitInterface (13 tools + guidelines) ├── Exception/ │ └── MysqlAdminException.php # Domain exception with static factories ├── Runtime/ │ ├── ConnectionManager.php # Multi-connection PDO pool │ ├── SchemaInspector.php # INFORMATION_SCHEMA-based introspection │ └── QueryResult.php # Markdown table formatting └── Tool/ ├── ConnectTool.php ├── DisconnectTool.php ├── ListConnectionsTool.php ├── QueryTool.php ├── SchemaTool.php ├── SchemaModifyTool.php ├── TransactionTool.php ├── ImportExportTool.php ├── BackupRestoreTool.php ├── OptimizeTool.php ├── AnalyzeTool.php ├── UserTool.php └── NiFiTemplateTool.php ``` License ------- [](#license) MIT ### Health Score 36 — LowBetter than 79% of packages Maintenance88 Actively maintained with recent releases Popularity0 Limited adoption so far Community6 Small or concentrated contributor base Maturity42 Maturing project, gaining track record Bus Factor1 Top contributor holds 100% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~1 days Total 2 Last Release 60d ago ### Community Maintainers ![](https://avatars.githubusercontent.com/u/597820?v=4)[Carmelo Santana](/maintainers/carmelosantana)[@carmelosantana](https://github.com/carmelosantana) --- Top Contributors [![carmelosantana](https://avatars.githubusercontent.com/u/597820?v=4)](https://github.com/carmelosantana "carmelosantana (2 commits)") ### Code Quality TestsPest Static AnalysisPHPStan Type Coverage Yes ### Embed Badge ![Health badge](/badges/coquibot-coqui-toolkit-mysql-admin/health.svg) ``` [![Health](https://phpackages.com/badges/coquibot-coqui-toolkit-mysql-admin/health.svg)](https://phpackages.com/packages/coquibot-coqui-toolkit-mysql-admin) ``` ### Alternatives [jdorn/sql-formatter a PHP SQL highlighting library 3.9k116.5M113](/packages/jdorn-sql-formatter)[propel/propel1 Propel is an open-source Object-Relational Mapping (ORM) for PHP5. 8361.6M87](/packages/propel-propel1)[mpociot/laravel-composite-key Support composite keys in your laravel app. 3544.8k1](/packages/mpociot-laravel-composite-key) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)