Warning

Still in development process.

A Modern SQLite Database Management System

---

In the age of data-driven applications, the demand for lightweight, scalable, and modern database solutions has never been greater. libSQL is a powerful fork of SQLite designed for the modern era, offering advanced features such as serverless and server-based modes, fine-grained access control, and native branching capabilities.

MylibSQLAdmin is an open-source web GUI built specifically for managing libSQL databases. By harnessing the full potential of libSQL-server functionalities, this project provides an intuitive and comprehensive platform for database administration, making it easier than ever to manage your database systems through an accessible web interface. You can connect with libsql-server from Docker Service or use your existing libsql-server instance.

What Does MylibSQLAdmin Offer?

• Simple Database Statistics - Get quick insights into your database performance with easy-to-understand stats.
• Database Management - Create, edit, and manage your databases with intuitive tools.
• Token Management - Secure and control access to your system using token-based authentication.
• Group Management - Organize users into groups for better structure and permission handling.
• Team Management - Collaborate efficiently by managing teams and their access levels.
• User Management - Easily handle user accounts, roles, and activity logs.
• Member Invitation Management - Invite new members and track their onboarding status with ease.

Sponsors

Support this Project

• via GitHub Sponsor (Global)
• via Saweria (Indonesian)

Getting Started

For now there is no build images, but you can use clone this repository and use MylibSQLAdmin.

1. Clone MylibSQLAdmin

git clone git@github.com:darkterminal/mylibsqladmin.git
./setup

or

git clone https://github.com/darkterminal/mylibsqladmin.git
./setup

2. Access Web GUI of MylibSQLAdmin Platform

http://localhost:8000

Using Existing libsql-server Instance

By default MylibSQLServer will use libsql-server from Docker Service. But if you want to try with your existing libsql-server instance you can do it too.

1. Clone MylibSQLAdmin

git clone git@github.com:darkterminal/mylibsqladmin.git

or

git clone https://github.com/darkterminal/mylibsqladmin.git

2. Setting Environment Variable File

cp .env.example .env
cp admin/.env.example admin/.env

3. adjust the settings

LIBSQL_LOCAL_INSTANCE=false

LIBSQL_HOST=<your-existing-libsql-server-host>
LIBSQL_PORT=<your-existing-libsql-server-port>

LIBSQL_API_HOST=<your-existing-libsql-server-admin-api-host>
LIBSQL_API_PORT=<your-existing-libsql-server-admin-api-port>
# Optional (you can leave username and password with empty value)
LIBSQL_API_USERNAME=<your-existing-libsql-server-admin-api-username>
LIBSQL_API_PASSWORD=<your-existing-libsql-server-admin-api-password>

4. Running MylibSQLAdmin Platform

cd admin
php artisan key:generate
composer install
npm install

cd ..

make compose-dev/up

5. Access Web GUI of MylibSQLAdmin Platform

http://localhost:8000

Contributors

Star History