{"repo":"martijndeb/liteadmin","free":true,"listed":false,"github":"https://github.com/martijndeb/liteadmin","clone":"git clone https://github.com/martijndeb/liteadmin.git","description":"A hostable SQLite browser and editor like phpMyAdmin, but for SQLite.","language":"JavaScript","stars":14,"topics":["admin-panel","dba","sql","sqlite"],"license":"MIT","category":"databases-storage","readme_excerpt":"LiteAdmin A hostable SQLite browser and editor like phpMyAdmin, but for SQLite. Standalone, no build step, no toolchain. Just serve the src/ folder with PHP. Built with the assistance of AI, and a lot of love for SQLite ❤️. Features Connect & browse - Login-protected, session + CSRF secured communication - Server databases via proxy.php (PDO/SQLite), local databases via in-browser sql.js (WASM) - Recent databases list (server and local), re-openable via the File System Access API - JSON-aware cells (click to pretty-view) and a validating JSON editor for JSON columns Schema & structure - Create databases; create tables, views and virtual tables with builders - Editable structure: rename table, add/rename/drop column, add/drop index - Per-table metrics (rows, columns, indexes, foreign keys) and per-table ANALYZE / REINDEX - Column/table profiler (distinct, nulls, min/max/avg per column) - Compare two tables, or two server databases, and generate migration SQL - Export the schema (DDL) or generate an OpenAPI/Swagger spec for the tables SQL & performance - Monaco SQL editor with autocomplete; run / run-as-script (wrappable in a transaction) - Query analyzer : EXPLAIN QUERY PLAN tree, full-bytecode EXPLAIN, performance hints with \"Fix this for me\" actions, single/covering index suggestions (one-click apply), auto-analyze on run, and a query benchmark Maintenance & operations - Maintenance dialog (integrity check, FK check, optimize, analyze, reindex, vacuum, WAL checkpoint) with a","default_branch":null,"files":null,"tree":[],"storefront":"/r/martijndeb","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/martijndeb/liteadmin/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}