Jet Bridge is an open-source Python application that generates a REST API from your SQL database so the Jet Admin SaaS can render a customizable back-office interface without directly accessing your data. Built by the Jet Admin team, Jet Bridge runs on your server and turns your existing database schema into CRUD endpoints consumed by Jet Admin's browser-based UI.
What is Jet Bridge?
Jet Bridge is a standalone backend app that connects SQL databases to Jet Admin, a SaaS admin-panel framework. It takes your database schema as input and outputs an auto-generated REST API with list, detail, create, update, and delete endpoints, which the Jet Admin interface renders as collection lists, forms, filters, dashboards, and custom actions. Jet Bridge is MIT-licensed, requires Python 2.7 or 3.4+, and supports PostgreSQL, MySQL, MariaDB, SQLite, Oracle, Microsoft SQL Server, BigQuery, Snowflake, Firebird, Sybase, CockroachDB, AWS Athena, ClickHouse, and Databricks.
Key Features
- CRUD operations — Automatically generated REST endpoints let you view, create, update, and delete records for every table in the database.
- Search and Filter — Filter records by any field with common lookups, search by text occurrence, and create SQL Segments for complex queries.
- Segments — Save an applied set of filters or a custom SQL query as a reusable segment for quick future access.
- WYSIWYG Interface Customization — Visually customize navigation menus, collection list views, and record create/update forms directly from the Jet Admin interface.
- List View Layouts — Choose between Table view, Kanban board, or a Map with markers to display records in different ways.
- Dashboards — Build charts, tables, and widgets to track KPIs without programming; complex data queries can be written in SQL.
- Teams and Permissions — Invite users to collaborate on a project and assign access rights based on team membership.
- Export — Export all or part of a collection to CSV or Excel files.
- Flex Extensions — Create custom views with any JS framework (React, Angular, etc.), custom actions that call backend logic, and custom fields computed by JavaScript functions.
Who is it for?
Jet Bridge is for development teams that need a back-office admin without writing repetitive CRUD code. Startups can deploy an internal tool quickly, and mature companies can put a configurable UI over an existing relational database. It's especially suited to teams that want to keep their data on their own infrastructure since Jet Admin never stores or directly accesses the underlying data.
Use cases
- Startup teams: install Jet Bridge alongside a new production database and get a working admin panel in minutes.
- Backend developers: extend the generated REST API with Flex Actions and Flex Fields to add business logic or computed values without building a separate admin frontend.
- Operations and support staff: use teams and permissions to give non-technical colleagues safe access to view, filter, and edit data through a responsive web interface.
How does Jet Bridge work?
Jet Admin is a SaaS frontend application that runs in the browser. Jet Bridge is installed on your side and connected to your SQL database; it automatically generates a REST API based on the database structure. The Jet Admin interface talks directly to Jet Bridge, so data is transferred from your database to your user's browser without passing through Jet Admin's servers.
To get started, create a project at app.jetadmin.io, install Jet Bridge, and connect it to your database; you'll be asked to sign in with a Jet account if you don't have one. Jet Bridge is a complete remake of the Django Jet admin interface and is MIT-licensed.
