CloudBeaver

CloudBeaver Database Management #

CloudBeaver is a web-based database management tool for browsing, querying, and managing the BonsAI Yugabyte database.

Features #

  • Visual database schema browser
  • SQL query editor with syntax highlighting and auto-completion
  • Data viewer and editor with filtering
  • ER diagram generation
  • Data export (CSV, JSON, SQL)
  • Query execution plans

Access #

In Coder Workspace #

  1. Start your workspace
  2. Click “Database” app in the workspace dashboard

Local Development # 

mise run dev
# Access at http://localhost:8978

First-Time Setup #

On first access, complete the setup wizard:

  1. Welcome → Click “Next”
  2. Server Configuration → Accept defaults → “Next”
  3. Admin Account:
    • Username: admin
    • Password: admin123
    • Confirm password: admin123
    • Click “Next” → “Finish”
  4. Login with admin / admin123

Add Database Connection #

After logging in:

  1. Click “Database” → “New Connection” (+ icon)

  2. Select “PostgreSQL”

  3. Enter details (choose one method):

    Method 1: Individual fields

    • Host: database
    • Port: 5432
    • Database: bonsai
    • Username: postgres
    • Password: postgres

    Method 2: Connection URL

    • Switch to “URL” tab
    • URL: jdbc:postgresql://database:5432/bonsai
    • Username: postgres
    • Password: postgres

  4. ✓ Save credentials

  5. Test Connection → Create

The Yugabyte database connection is now ready.

Common Tasks #

Browse Database #

  • Expand connection in left sidebar
  • Navigate: Databases → bonsai → Schemas → public → Tables
  • Click table to view data

Run SQL Queries #

  1. Press Ctrl+Q or click SQL Editor icon
  2. Write query
  3. Press Ctrl+Enter to execute
-- Example: View recent documents
SELECT id, name, created_at
FROM documents
ORDER BY created_at DESC
LIMIT 10;

View ER Diagram #

Right-click schema or table → “View Diagram”

Export Data #

  1. Execute query or view table
  2. Click Export button
  3. Choose format: CSV, JSON, SQL, HTML, XML

Tips #

  • Use LIMIT in queries for large tables
  • Save frequently used queries for reuse
  • Use filters in data viewer for better performance
  • Check Save credentials when adding connections

Troubleshooting #

Cannot Connect #

  1. Check database: docker ps | grep yugabyte
  2. Use host database (not localhost)
  3. View logs: docker logs bonsai-yugabyte

Session Timeout #

Settings → Server Configuration → Increase Session Lifetime

Slow Performance #

  • Add LIMIT and WHERE clauses
  • Use EXPLAIN ANALYZE for query optimization
  • Consider adding indexes

Resources #