FEATURES
PRICING

Why Commonwealth?

We strive to be the simplest-to-use relational database. We've built tools to help you write SQL, manage your schemas, share your data, and optimize your queries.


  • Fully managed database: no operations, automatic and transparent upgrades
  • Automatic backups, easy restores
  • Accessible from anywhere, access over the internet
  • Rich query language: SQL (ANSI:2011 standard)



QUERY FROM WEB

Beautiful web console

Write queries using a rich web console which gives you easy and immediate access to your data using SQL. It helps you write queries with autocomplete and quick feedback, then saves them for later.

COMMAND-LINE

Powerful CLI

Our Command-Line Interface lets you quickly select data, manipulate your tables, execute transactions, etc. It's designed to be a powerful tool for your development workflow.

  • Full SQL language in an interactive shell
  • Autocomplete table names and SQL keywords
  • Execute transactions with multiple queries
  • Execute SQL directly from bash

QUERY LANGUAGE

Standardized SQL

Our SQL is based on the ANSI:2011 SQL standard. We added syntax to strengthen the language's capabilities and make development easier. We embedded a full SQL parser in the SQL web console and CLI, which enables immediate syntax checking, type checking, and autocomplete.

  • INSERT, UPDATE, DELETE (DML) queries
  • CREATE TABLE, etc. (DDL) queries
  • CREATE TRANSACTION, COMMIT queries
  • Metadata queries like SHOW TABLES

DEV TOOLING

This is built to make you a more productive developer. We've drawn on our experience running critical production databases to create tools that optimize your workflow when managing the persistence layer of your app.


  • Observability
    Watch a real-time stream of queries to your tables, ideal for writing and debugging apps.
  • Table Migrations
    You can configure your schemas declaratively and have Commonwealth automatically run migrations for you.
  • Query Optimization
    Commonwealth identifies and ranks your most expensive queries.

Sign Up
Ready to try Commonwealth?   

ACCESS CONTROL

Seamlessly manage permissions

Our table-access permissions are designed to help you collaborate with other developers and applications. You can select individual capabilities (like read, write, create table, etc) and assign them to individual users or access tokens. You can even host an open data set by making a table public to the world.


TRADE-OFFS

Why not Commonwealth?


This product is intended for application developers who want a powerful relational database that's also easier to use. It doesn't fit with every use case; use this table to help evaluate if it's a good option for you.


Not intended forOptimized for
You’re doing analytics on a huge data set - in that case you need an OLAP database like BigQuery.You’re writing an application and need a database to power it.
You need to run the database on your own machines. Commonwealth in fully hosted and can’t be run locally.You want a fully hosted database.
You need a database that exactly matches MySQL or PostgreSQL query language or wire protocol.You want a new relational database optimized for ease-of-use and scaling.
You need query response times less than XXms. Commonwealth is optimized for applications that can query with latencies in the 25-50ms range.You want a database accessible from anywhere.
You want to store mostly unstructured data. In that case a relational database isn't the best choice and a key-value store or NoSQL database may fit better.You want typed schemas for your data.


DocumentationSign Up