Quick Start

This page is a concise command reference.
For a guided first run, see First Session (10 Minutes).

Create a database

murodb mydb.db --create -e "CREATE TABLE t (id BIGINT PRIMARY KEY, name VARCHAR)"

You will be prompted for an encryption password.

If you need plaintext mode, opt in explicitly:

murodb mydb_plain.db --create --encryption off -e "CREATE TABLE t (id BIGINT PRIMARY KEY, name VARCHAR)"

Insert rows

murodb mydb.db -e "INSERT INTO t (id, name) VALUES (1, 'hello'), (2, 'world')"

Query rows

murodb mydb.db -e "SELECT id, name FROM t ORDER BY id"

Show tables

murodb mydb.db -e "SHOW TABLES"

Run with JSON output

murodb mydb.db --format json -e "SELECT id, name FROM t ORDER BY id"

Interactive REPL

murodb mydb.db

Start without -e to enter the interactive REPL mode.