The database engine that powers every BeanSuite app.
BeanDB is the shared database backbone of the entire BeanSuite ecosystem. It provides a visual SQLite database manager with table browsing, a SQL query editor, key-value storage, and a REST API. Every BeanSuite app stores its data through BeanDB.
Write and execute SQL queries with syntax highlighting. View results in a sortable, paginated table.
Browse all tables with full CRUD operations. Add, edit, and delete rows with inline editing.
Simple key-value API used by all BeanSuite apps. Scoped by app name for clean data separation.
Inspect table schemas, column types, indexes, and foreign keys. Understand your data structure at a glance.
Each app can have its own SQLite database or share the default one. Full isolation between apps.
Full HTTP API for all operations — query, insert, update, delete, schema inspection. Powers the entire suite.
JWT authentication with user, team, and public scoping. Role-based access control (admin, user, viewer).
BeanDB Connect Dialog lets any BeanSuite app point to a remote server. Work from home, office, or anywhere.