A modern, developer-friendly database administration tool for PostgreSQL and SQLite. DBOC offers a clean UI, fast workflow, and essential features for managing your databases. The MVP is now released—advanced features are in progress!

DBOC Demo

🚀 MVP Features

Connect to Databases: PostgreSQL and SQLite supported (MySQL/MariaDB, DuckDB coming soon)
Browse Schemas & Tables: Visual navigation of schemas, tables, and columns
Table Data Grid: View, filter, sort, and paginate table data
Edit Data: Insert, update, and delete rows
Run SQL Queries: Execute custom SQL, view results, and query history
Schema Management: Add/drop columns, manage indexes and foreign keys (PostgreSQL)
Query History: Track and review previous queries
Modern UI/UX: Responsive, dark/light themes, keyboard shortcuts

🛠️ Technology Stack

Frontend: Next.js 14, TypeScript, Tailwind CSS, shadcn/ui, Zustand, React Query, Monaco Editor
Backend: Next.js API Routes, Node.js
Database Drivers: pg, better-sqlite3
Dev Tools: ESLint, Prettier, Jest, Storybook, Docker

⚡ Quick Start

Local Development

Install dependencies

pnpm install

Run the app
```
pnpm dev
```
Visit http://localhost:3000

Docker

Run the latest release with Docker:

docker run -p 3000:3000 niradler/dboc

🧩 API Overview

DBOC exposes RESTful endpoints for all major operations. Example endpoints:

GET /api/connections — List all connections
POST /api/connections — Add a new connection
GET /api/connections/:id/schema — List schemas
GET /api/connections/:id/schema/:schema/tables — List tables
GET /api/connections/:id/schema/:schema/tables/:table — Get table data (with pagination, filtering, sorting)
POST /api/connections/:id/schema/:schema/tables/:table — Insert row
PUT /api/connections/:id/schema/:schema/tables/:table — Update row
DELETE /api/connections/:id/schema/:schema/tables/:table — Delete row
POST /api/connections/:id/query — Run custom SQL
GET /api/history — Query history