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
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