Skip to content

monorka/tabletrace-oss

TableTrace

🇯🇵 日本語

Real-time visualization of database changes across multiple tables.

TableTrace

Features

Real-time Table Watching

Monitor INSERT, UPDATE, DELETE operations as they happen. Watch multiple tables simultaneously with color-coded changes.

Real-time Table Watching

Event Timeline

Chronological view of all database changes with correlation grouping.

Event Timeline

ERD Visualization

Interactive Entity Relationship Diagram with drag-and-drop positioning, foreign key relationships, and schema filtering.

ERD Visualization

Dry Run Mode

Test SQL queries safely - changes are rolled back, database is not modified.

Dry Run Mode

Change Highlighting

  • 🟢 Green: INSERT (new rows)
  • 🟡 Yellow: UPDATE (modified rows)
  • 🔴 Red: DELETE (removed rows)

Supported Databases

  • PostgreSQL (Local)
  • Supabase (Local development via Docker)

Quick Start (with Sample Database)

Try TableTrace with a pre-configured sample database:

# 1. Start sample PostgreSQL
docker compose -f demo/docker-compose.yml up -d

# 2. Run TableTrace
npm run tauri dev

# 3. Connect with these settings:
#    Host: localhost
#    Port: 5432
#    Database: tabletrace_sample
#    User: postgres
#    Password: postgres

Test database changes:

# INSERT
docker exec tabletrace-postgres psql -U postgres -d tabletrace_sample \
  -c "INSERT INTO users (name, email) VALUES ('Test User', 'test@example.com');"

# UPDATE
docker exec tabletrace-postgres psql -U postgres -d tabletrace_sample \
  -c "UPDATE products SET price = 39.99 WHERE id = 1;"

# DELETE
docker exec tabletrace-postgres psql -U postgres -d tabletrace_sample \
  -c "DELETE FROM users WHERE email = 'charlie@example.com';"

Stop the sample database:

docker compose -f demo/docker-compose.yml down -v

Installation

Prerequisites

Development

# Clone the repository
git clone https://github.com/monorka/tabletrace-oss.git
cd tabletrace-oss

# Install dependencies
npm install

# Run in development mode
npm run tauri dev

Build

npm run tauri build

Usage

  1. Click "Connect" and enter your PostgreSQL connection details
  2. Click on tables in the sidebar to start watching
  3. Changes appear in real-time with color-coded highlights
  4. Switch to ERD tab to visualize table relationships
  5. Use Dry Run to test SQL queries without committing

Tech Stack

Layer Technology
Frontend React 19, TypeScript, Tailwind CSS
Backend Rust, Tauri 2
Database PostgreSQL (tokio-postgres)
Visualization React Flow, Dagre

License

AGPL-3.0

Contributing

Pull requests welcome.

Pro Version (Planned)

  • Supabase Cloud connection with Logical Replication
  • Real-time change propagation visualization
  • Export (PNG/SVG/PDF)
  • Multiple connections

About

No description, website, or topics provided.

Resources

License

Code of conduct

Contributing

Security policy

Stars

Watchers

Forks

Sponsor this project

Packages

No packages published

Contributors 2

  •  
  •  

Languages