Getting started

Choose your deployment model first:

• Managed Centia Cloud: Sign up and create a backend
• Self-hosted with Docker: Open source and self-hosting guide

Then pick whichever interface suits you — Web App, CLI, or API. All three give you access to the full platform.

Web App

The Centia Web App is the fastest way to get started. After creating a backend, open the console and you can visually manage schemas, tables, columns, users, clients, and more — no code required.

Install the CLI

npm

npm install @centia-io/cli --global

Yarn

yarn global add @centia-io/cli

pnpm

pnpm add @centia-io/cli --global

Use the CLI

Start by logging in to your backend:

centia login

Create a new schema for your tables:

centia schema add "rollhall"

Create a new table in the schema:

centia table add "rollhall" "inductees"

Add columns in your table:

centia column add "rollhall" "inductees" "id" int
centia column add "rollhall" "inductees" "name" varchar

Then add a primary key to your id column:

centia constraint add "rollhall" "inductees" "id" primary

Now your table is ready for data inserts:

echo "INSERT into rollhall.inductees values(1, ‘Guns n’’ Roses’)" | centia sql

Run queries on your table:

echo "select * from rollhall.inductees" | centia sql