PHPackages coquibot/coqui-toolkit-sqlite-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. coquibot/coqui-toolkit-sqlite-admin ActiveLibrary coquibot/coqui-toolkit-sqlite-admin =================================== SQLite database administration toolkit for Coqui — create, query, manage schemas, backup/restore, and vector search across multiple SQLite databases v0.1.0(1mo ago)01↓100%MITPHPPHP ^8.4CI passing Since Mar 20Pushed 1mo agoCompare [ Source](https://github.com/carmelosantana/coqui-toolkit-sqlite-admin)[ Packagist](https://packagist.org/packages/coquibot/coqui-toolkit-sqlite-admin)[ RSS](/packages/coquibot-coqui-toolkit-sqlite-admin/feed)WikiDiscussions main Synced 1mo ago READMEChangelog (1)Dependencies (3)Versions (2)Used By (0) SQLite Admin Toolkit for Coqui ============================== [](#sqlite-admin-toolkit-for-coqui) A comprehensive SQLite database administration toolkit for the [Coqui](https://github.com/carmelosantana/coqui) bot platform. Provides 12 tools covering database connectivity, SQL execution, schema management, backup/restore, vector search, and query analysis. Features -------- [](#features) - **Multi-database connections** — open up to 10 SQLite databases simultaneously with alias-based switching - **SQL query execution** — parameterized queries with auto-LIMIT, write detection, and markdown-formatted results - **Schema management** — inspect tables/indexes/views, create/alter/drop with JSON column definitions - **Import/Export** — CSV and JSON import with auto-table creation, CSV/JSON export, full SQL dump - **Backup & Restore** — consistent backups via VACUUM INTO, clone databases, restore from backup files - **Vector store & RAG** — SQLite-backed vector storage with FTS5 full-text search and cosine similarity - **Query analysis** — EXPLAIN QUERY PLAN, index suggestions, unused index detection - **Transactions** — BEGIN/COMMIT/ROLLBACK with savepoint support for nested operations - **Database optimization** — VACUUM, ANALYZE, integrity checks, WAL checkpoints, PRAGMA reporting Requirements ------------ [](#requirements) - PHP 8.4+ - `ext-pdo_sqlite` Installation ------------ [](#installation) ``` composer require coquibot/coqui-toolkit-sqlite-admin ``` The toolkit registers itself automatically via Coqui's auto-discovery system. No additional configuration needed. Tool Reference -------------- [](#tool-reference) ToolDescription`sqlite_connect`Open or create a SQLite database`sqlite_disconnect`Close a database connection`sqlite_databases`List all open connections`sqlite_query`Execute SQL queries with parameterized statements`sqlite_schema`Inspect database schema (tables, columns, indexes, views, triggers)`sqlite_schema_modify`Create/alter/drop tables, indexes, and views`sqlite_import_export`Import CSV/JSON, export data, generate SQL dumps`sqlite_backup_restore`Backup, restore, and clone databases`sqlite_optimize`VACUUM, ANALYZE, integrity checks, PRAGMA tuning`sqlite_vector`Vector storage with FTS5 search and cosine similarity`sqlite_analyze`Query plan analysis and index suggestions`sqlite_transaction`Transaction management with savepoint supportUsage Examples -------------- [](#usage-examples) ### Connect and Query [](#connect-and-query) ``` sqlite_connect(path: "myapp.db") sqlite_query(sql: "SELECT * FROM users WHERE active = :active", params: '{"active": 1}') ``` ### Create a Table [](#create-a-table) ``` sqlite_schema_modify( action: "create_table", table: "products", columns: '[ {"name": "id", "type": "INTEGER", "pk": true, "autoincrement": true}, {"name": "name", "type": "TEXT", "notnull": true}, {"name": "price", "type": "REAL", "default": 0.0}, {"name": "category_id", "type": "INTEGER", "references": "categories(id)"} ]' ) ``` ### Vector Store (RAG) [](#vector-store-rag) ``` sqlite_vector(action: "create_store", store: "knowledge_base") sqlite_vector(action: "add", store: "knowledge_base", text: "PHP 8.4 introduces property hooks and asymmetric visibility.") sqlite_vector(action: "add", store: "knowledge_base", text: "SQLite supports FTS5 for full-text search.", embedding: "[0.1, -0.3, ...]") sqlite_vector(action: "search", store: "knowledge_base", text: "property hooks in PHP") ``` ### Import CSV Data [](#import-csv-data) ``` sqlite_import_export( action: "import_csv", table: "sales", content: "date,amount,customer\n2024-01-15,299.99,Acme Corp\n2024-01-16,149.50,Widgets Inc" ) ``` ### Backup and Optimize [](#backup-and-optimize) ``` sqlite_backup_restore(action: "backup") sqlite_optimize(action: "vacuum") sqlite_optimize(action: "analyze") sqlite_analyze(action: "explain_plan", sql: "SELECT * FROM orders WHERE customer_id = 42") ``` ### Transactions [](#transactions) ``` sqlite_transaction(action: "begin") sqlite_query(sql: "UPDATE accounts SET balance = balance - 100 WHERE id = 1") sqlite_query(sql: "UPDATE accounts SET balance = balance + 100 WHERE id = 2") sqlite_transaction(action: "commit") ``` Gated Operations ---------------- [](#gated-operations) The following destructive operations require user confirmation (unless `--auto-approve` is enabled): - `sqlite_schema_modify` — `drop_table`, `drop_index`, `drop_view` actions - `sqlite_backup_restore` — `restore` action - `sqlite_query` — write operations (INSERT, UPDATE, DELETE, etc.) Path Resolution --------------- [](#path-resolution) Database paths resolve in this order: 1. `:memory:` — in-memory database 2. Absolute paths — used as-is 3. `~` prefix — expands to home directory 4. Relative paths — resolve under the workspace `databases/` directory Allowed file extensions: `.db`, `.sqlite`, `.sqlite3`, `.sqlite-journal`, `.s3db` Development ----------- [](#development) ``` # Install dependencies composer install # Run tests ./vendor/bin/pest # Static analysis ./vendor/bin/phpstan analyse ``` License ------- [](#license) MIT ### Health Score 38 — LowBetter than 84% of packages Maintenance96 Actively maintained with recent releases Popularity2 Limited adoption so far Community6 Small or concentrated contributor base Maturity41 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 Unknown Total 1 Last Release 49d 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 (1 commits)") ### Code Quality TestsPest Static AnalysisPHPStan Type Coverage Yes ### Embed Badge ![Health badge](/badges/coquibot-coqui-toolkit-sqlite-admin/health.svg) ``` [![Health](https://phpackages.com/badges/coquibot-coqui-toolkit-sqlite-admin/health.svg)](https://phpackages.com/packages/coquibot-coqui-toolkit-sqlite-admin) ``` PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)