Jet Admin
Welcome to Jet Admin, a powerful web-based PostgreSQL management and visualization platform.
Overview
Jet Admin is a comprehensive solution for managing PostgreSQL databases through an intuitive web interface. It combines robust database management capabilities with powerful visualization tools, making it ideal for both developers and operations teams.
Core Features
Database Management
- Data Manipulation Language
- Insert
- Update
- Delete
- Select
- Bulk Delete
- Bulk Update
- Bulk Insert
- Data Definition Language (DDL)
- Create
- Alter
- Drop
- Truncate
Queries
- PostgreSQL Queries
- Create query
- Edit query
- Delete query
- Run query
- Duplicate query
- Javascript-based Query
- Rest API-based Query
Charts
- Line chart
- Bar chart
- Pie chart
- Radial chart
- Doughnut chart
- Polar chart
- Radar chart (new)
- Scatter chart (new)
- Bubble chart (new)
Authentication
- Firebase Authentication
- Google Authentication
- Email Authentication
- Phone Authentication
- Facebook Authentication
- Twitter Authentication
- Github Authentication
- Apple Authentication
- Microsoft Authentication
- JWT-based authentication
Authorization
- Global roles
- Tenant specific roles
- Permissions (per API)
- Map permissions to roles
- Map roles to users
- Asset level permissions
Topics to cover
- Setup: To get started with the project, follow the instructions in the Frontend Setup and Backend Setup sections to set up the frontend and backend components respectively.
- Concepts
- Database Schemas
- Tables
- Queries
- Charts
- Widgets
- Dashboards
- Accounts
- Authentication
- Authorization
- Scheduling (coming soon)