Skip to content

Simple PostgreSQL GUI for visualizing your databases ,tables and their column types

Notifications You must be signed in to change notification settings

tigawanna/postbase

Repository files navigation

POSTBASE

An attempt at a Nodejs based PostgresSQL GUI

Main postbase image

Getting started

  • clone locally
  • have a running Postgres server
  • make sure you have a default Postgres with the settings
postgres({
       host: "localhost",
       user: "postgres",
       password: "postgres",
       database: "postgres",
     })

Connection url can be used but types generation only works on local database

 npm install
 npm run dev

for best results build and run it first

npm run build
npm start

To use the TypeORM + TypeGraphQL classes add an environment variable with your Gemini API key, its free for simple uses.

postbase.mp4

The output types and classes are stored in the pg directory

built using

  • Rakkasjs Vite frontend + Nodejs backend + useServerSideQuery data fetching hooks

  • Shadcn/UI + Tailwindcss Stylings and components

  • Postgresjs: low level ORM for PostgresSQL

  • kanel: Tool for generating typescript types from Postgres

  • Gemini AI To generate TypeORM + TypeGraphQL classes

  • Shikiji Syntax highlighter , used to style the code blocks Shikiji highlighted code

About

Simple PostgreSQL GUI for visualizing your databases ,tables and their column types

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages