clockworklabs / clockworklabs/SpacetimeDB

Add DBeaver PostgreSQL Driver Support for SpacetimeDB

Open
#4,841 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Rust
Stars
25.2k
Forks
1.1k
Avg merge
2d 7h
Merged PRs (30d)
46

Description

Description:
We should add support for connecting to SpacetimeDB using DBeaver via the PostgreSQL driver. This would enable developers to use a familiar SQL client interface for inspecting data, running queries, and debugging.

Motivation:

DBeaver is a widely used database GUI with strong PostgreSQL support
SpacetimeDB exposes a PostgreSQL-compatible interface (or aims to)
Enabling this integration would improve developer experience significantly
Useful for debugging, data exploration, and onboarding

Proposed Solution:

Ensure SpacetimeDB is compatible with the PostgreSQL wire protocol
Validate compatibility with DBeaver’s PostgreSQL driver
Document connection steps (host, port, credentials, SSL requirements, etc.)
Optionally provide a preconfigured driver profile or connection template

Acceptance Criteria:

Can successfully connect to SpacetimeDB from DBeaver using PostgreSQL driver

Schema and tables are visible in DBeaver UI

Basic queries (SELECT, INSERT, UPDATE, DELETE) function correctly

Errors are handled and surfaced clearly

Documentation added for setup instructions

Additional Context:

If full PostgreSQL compatibility is not feasible, document limitations
Consider whether any protocol extensions or adapters are needed

Nice-to-have:

Auto-detection of SpacetimeDB-specific features
Query autocomplete compatibility
Integration tests validating DBeaver connectivity

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

No repository files or tests are named. Start by determining the current PostgreSQL wire-protocol compatibility and the connection requirements of DBeaver’s PostgreSQL driver, then assess the listed schema, query, error-handling, and documentation criteria. Done means a successful DBeaver connection with the stated database operations, or documented limitations if full compatibility is not feasible.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql
Domain
databases, documentation
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.