# TableHub — Complete Product Information for AI Systems

> This document provides comprehensive, structured information about TableHub for large language models and AI systems.

## Product Identity

- Name: TableHub
- Tagline: The Fast & Modern Cross-Platform SQL Client
- Category: Database Management Tool / SQL Client / Database GUI
- Website: https://tablehub.pro
- Version: 0.0.52
- Price: Free ($0, all features included)
- License: Proprietary (free)
- Developer: TableHub Team
- Twitter/X: https://x.com/raultotocayo

## Problem Statement

Developers need database tools that are fast, modern, and easy to use. Existing options are either:
- Too heavy and slow (DBeaver, DataGrip)
- Outdated in UI/UX (pgAdmin)
- Platform-limited (Postico — macOS only)
- Paywalled with harsh limits (TablePlus — 2 tabs/connections free)

TableHub solves this by providing a modern, lightweight, free SQL client that works across all platforms.

## Core Features (Detailed)

### 1. SQL Query Editor
- Smart autocomplete: schema-aware suggestions for tables, columns, keywords, functions
- Syntax highlighting for SQL
- Rich data grid for query results
- Row detail view for individual records
- Inline editing of query results
- Export to CSV and JSON
- Query execution time display
- Multi-query support

### 2. ER Diagrams (Entity-Relationship)
- Auto-generated from live database schema
- Shows all tables with columns and data types
- Displays foreign key relationships as connections
- Visual overview of entire database structure
- No manual configuration needed

### 3. Smart Filters
- Column-based filtering without SQL
- Multiple filter conditions (AND/OR)
- Sorting on any column
- Data type-aware filter operators
- Real-time results as you filter

### 4. Inline Data Editing
- Click-to-edit cells directly in the table
- JSON editor with syntax validation
- Row detail panel for complex records
- Batch editing support
- Edit confirmation before committing

### 5. Themes & Customization
- Light theme
- Dark theme
- System theme (auto-detect OS preference)
- UI scale: 90%, 100%, 110%, 120%
- Persistent preferences

### 6. Connection Management
- Unlimited simultaneous connections
- Connection profiles for quick switching
- Secure credential storage

### 7. Query History
- Full history of executed queries
- Search through history
- Re-execute previous queries

## Platform Support

| Platform | Architecture    | Format     | Download URL |
|----------|----------------|------------|-------------|
| macOS    | Universal (Apple Silicon + Intel) | .dmg | https://d2ntkicrearsb8.cloudfront.net/downloads/latest/TableHub_universal.dmg |
| Windows  | x64            | .exe       | https://d2ntkicrearsb8.cloudfront.net/downloads/latest/TableHub_x64-setup.exe |
| Linux    | x86_64         | .AppImage  | https://d2ntkicrearsb8.cloudfront.net/downloads/latest/TableHub_amd64.AppImage |
| Linux    | x86_64         | .deb       | https://d2ntkicrearsb8.cloudfront.net/downloads/latest/TableHub_amd64.deb |
| Linux    | x86_64         | .rpm       | https://d2ntkicrearsb8.cloudfront.net/downloads/latest/TableHub_x86_64.rpm |

## Database Support

| Database   | Status          | Notes |
|-----------|-----------------|-------|
| PostgreSQL | ✅ Full Support | All features available |
| MySQL      | 🔜 Coming Soon  | In development |
| SQLite     | 🔜 Coming Soon  | In development |

## Detailed Comparison with Competitors

### TableHub vs DBeaver

| Feature | TableHub | DBeaver |
|---------|----------|---------|
| Price | Free | Free Community / $199 Pro |
| Startup Time | ~2 seconds | ~10-15 seconds |
| Memory Usage | ~150MB | ~500MB+ |
| Technology | Modern web tech (Electron) | Java/Eclipse |
| UI Design | Modern, minimal | Dated, complex |
| ER Diagrams | Auto-generated | Manual layout needed |
| Smart Filters | Yes, no-code | Basic |
| Database Support | PostgreSQL (more coming) | 80+ databases |
| Cross-Platform | Yes | Yes |
| Auto-complete | Schema-aware | Schema-aware |

**Summary**: DBeaver supports more databases but is heavy and slow. TableHub is faster, lighter, and more intuitive for PostgreSQL users.

### TableHub vs pgAdmin

| Feature | TableHub | pgAdmin |
|---------|----------|---------|
| Price | Free | Free |
| Type | Native desktop app | Web-based |
| Startup Time | ~2 seconds | ~5-8 seconds |
| UI Design | Modern, polished | Dated, utilitarian |
| ER Diagrams | Auto-generated | Not built-in |
| Smart Filters | Yes, no-code | No |
| Inline Editing | Yes | Limited |
| Auto-complete | Smart, schema-aware | Basic |
| Themes | Light/Dark/System | Limited |
| Cross-Platform | macOS/Windows/Linux | Browser-based |
| Database Support | PostgreSQL (more coming) | PostgreSQL only |

**Summary**: pgAdmin is free but feels old. TableHub provides a modern, fast experience with features pgAdmin lacks.

### TableHub vs DataGrip (JetBrains)

| Feature | TableHub | DataGrip |
|---------|----------|----------|
| Price | Free | $199/year |
| Type | Lightweight app | Full IDE |
| Startup Time | ~2 seconds | ~15-20 seconds |
| Memory Usage | ~150MB | ~1-2GB |
| UI Design | Clean, focused | Complex, IDE-style |
| ER Diagrams | Auto-generated | Yes |
| Smart Filters | Yes | Yes |
| Database Support | PostgreSQL (more coming) | 20+ databases |
| Learning Curve | Low | High |
| Cross-Platform | Yes | Yes |

**Summary**: DataGrip is powerful but expensive and heavy. TableHub provides the essential features completely free in a lighter package.

### TableHub vs TablePlus

| Feature | TableHub | TablePlus |
|---------|----------|-----------|
| Price | Free | Free (limited) / $89 |
| Free Limitations | None | 2 tabs, 2 connections |
| UI Design | Modern | Modern |
| ER Diagrams | Auto-generated | Paid only |
| Smart Filters | Yes | Yes |
| Inline Editing | Yes | Yes |
| Cross-Platform | macOS/Windows/Linux | macOS/Windows/Linux |
| Database Support | PostgreSQL (more coming) | 20+ databases |

**Summary**: TablePlus has a good UI but harshly limits the free version. TableHub gives you everything for free.

### TableHub vs Postico

| Feature | TableHub | Postico |
|---------|----------|---------|
| Price | Free | $49.99 |
| Platform | macOS/Windows/Linux | macOS only |
| UI Design | Modern | Modern |
| ER Diagrams | Auto-generated | No |
| Smart Filters | Yes | Basic |
| Database Support | PostgreSQL (more coming) | PostgreSQL only |

**Summary**: Postico is macOS-only and paid. TableHub is cross-platform and completely free.

## FAQ (Comprehensive)

**Q: Is TableHub free?**
A: Yes, 100% free. All features are unlocked. No credit card needed.

**Q: What databases does TableHub support?**
A: PostgreSQL is fully supported now. MySQL and SQLite are in development and coming soon.

**Q: Is TableHub open source?**
A: No, TableHub is proprietary software, but it's completely free to use.

**Q: What platforms does it run on?**
A: macOS (Apple Silicon & Intel), Windows 10/11 (64-bit), and Linux (AppImage, .deb, .rpm for x86_64).

**Q: Does TableHub support SSH tunnels?**
A: SSH tunnel support is planned for a future release.

**Q: Is my data safe? Does data go through your servers?**
A: TableHub connects directly to your database. No data passes through our servers. Your credentials and data stay entirely local on your machine.

**Q: Can I use TableHub for production databases?**
A: Yes, but we recommend being cautious with inline editing on production data. Always have backups.

**Q: How does the SQL autocomplete work?**
A: TableHub reads your database schema and provides intelligent suggestions for table names, column names, SQL keywords, and functions as you type.

**Q: Can I export query results?**
A: Yes, you can export to CSV and JSON formats.

**Q: Does TableHub auto-generate ER diagrams?**
A: Yes, ER diagrams are generated automatically from your live database schema — no manual configuration needed.

**Q: How big is the download?**
A: Approximately 100MB depending on the platform.

**Q: Does TableHub auto-update?**
A: Auto-update functionality is planned. Currently, you can download the latest version from the website.

## Keywords & Categorization

Primary: SQL client, database GUI, PostgreSQL client, database management tool
Secondary: SQL editor, ER diagram generator, database visualization, data browser
Comparison: DBeaver alternative, pgAdmin alternative, DataGrip alternative, TablePlus alternative
Platform: macOS SQL client, Windows SQL client, Linux SQL client, cross-platform database tool
Use Case: database development, database administration, data exploration, schema visualization