Connect your SQLite database and get a self-hosted admin panel for managing your data. Self-hosted, secure, and open-source.
Just run the CLI to set up your admin panel in minutes. It's that easy.
Connect your local app to your SQLite database. Keep your credentials private.
Kottster analyzes your schema and generates an instant admin panel.
Use Kottster to create CRUD tables for your SQLite data. It provides a simple interface for managing your records.
Modify your tables by adjusting the layout, logic, and functionality. You can use the visual editor or control everything through code.
If your table has a foreign key, Kottster shows a preview of the related record. And otherwise, when other tables reference it, Kottster adds a column with those linked records.
Create custom pages like dashboards, forms, charts, or settings. If you know JavaScript and React, you can build full pages with UI and API logic.
To connect a SQLite database, just specify the path to your SQLite file in the visual form, or create a config file in your project. Kottster uses Knex with the sqlite3 client for connection, so you can configure it as needed.
Kottster opens a single connection to your SQLite database and runs only user-initiated CRUD queries. It doesn't affect performance, as it just runs the queries you trigger.
Yes. The Kottster app runs locally on your machine or server, and all data stays in your environment. Our platform never access your database or credentials.
No data storage on our servers. Your SQLite data remains completely within your application. Only your app's frontend accesses the backend database. Check our data protection details.
Your Kottster app reads the SQLite schema at startup and caches it. If you change the schema, just restart the app to update the cache. All existing pages will continue to work without needing regeneration.
DBeaver and DBBrowser are tools for developers to work directly with the database. Kottster lets you build an admin panel that non-technical users can use to manage data without direct database access.
