Jet Admin

Let's discover Jet Admin in less than 10 minutes.

Intro

Welcome to Jet Admin, a web-based PostgreSQL tables manager and admin dashboard for your operations! Edit data, build graphs, and create dashboards using queries.

Features

Database Management

• Data Manipulation Language
  • Insert
  • Update
  • Delete
  • Select
  • Bulk Delete
• 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

Graphs

• Line graph
• Bar graph
• Pie graph
• Radial graph
• Doughnut graph
• Polar graph

Authentication

• JWT-based local user authentication

Authorization

• JSON-based policy editor
• GUI-based policy editor
• Fine-grained RBAC
• Prisma-based RBAC for tables
• Record-based RBAC for queries, graphs, and dashboards

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.
• Tables
• Queries:
• Graphs
• Scheduled Jobs
• App Constants
• Policies
• Accounts