# HTQLDB Data Ready | Four data models, one database, one language

> HTQLDB Data Ready: relational, graph, document and key-value data in one PostgreSQL 18 based database, with your own schemas beside the native commerce and finance models, one query language and one permission model.

URL: https://sigmar.au/htqldb/data
Organisation: Sigmar AOS (trading name of Sigmar Investment)

*HTQLDB · Data Ready*

## Four data models. One database. One language.

Build with relational, graph, document and key-value data in one extensible PostgreSQL-based database. Define your own schemas and query them with HTQL.

- [Explore the data models](#models)
- [Build with HTQLDB](https://sigmar.au/pricing)

### PostgreSQL 18

### Custom schemas

### One permission model

*The data foundation*

## Choose the shape that fits your data.

When applications spread data across separate relational, graph and document stores, teams need to reconcile their relationships and permissions. HTQLDB brings these models together under one language.

> Rows when you need rules. Graphs when you need relationships. Documents and key-value when you need flexibility.

## Different shapes. Connected by design.

### Relational

Typed tables, joins and transactions, backed by PostgreSQL.

LOOKUP · JOIN

### Graph

Connect records, traverse multiple hops and find shortest paths.

BFS · DFS · SHORTEST_PATH

### Document

Define content types and store flexible JSON with dot-path access.

JSON · NEST

### Key-value

Read and write values by key, with no table design for the built-in store.

KV

*Built for developers*

## Your data. Your schema. Your application.

Create custom schemas, tables and relationships alongside native commerce and finance models. Use the same HTQL language and access controls for both.

- [Explore HTQL in practice](https://sigmar.au/ai/htql.md)

### Your custom schemas

### Native business models

### HTQL language

## Connect records wherever they belong.

Edges live beside the records they connect. Global IDs let an order, a customer, a Persona and a capability share relationships across data shapes.

Conceptual graph

### Multi-hop traversal

### Shortest paths

### Pruning

### BFS / DFS

### Order

### Customer

### Persona

### Capability

## Query the way you think.

Illustrative HTQL excerpts

Aggregate with LEARN, JOIN and GROUP inside the database. Return the summary instead of moving the entire dataset.

- [Explore Formula Ready](https://sigmar.au/htqldb/formulas)

### Relational

LOOKUP(orders,
  WHERE(status = "fulfilled"),
  TAKE(50))

### Document filter

FILTER(customer.lastname = "Nguyen")

### Key-value

KV("trial_days")

## One foundation. Your choice of deployment.

Governed access applies to data operations.

### Cloud hosted

Get up and running in seconds.

### Enterprise isolation

Host on your own premises.

### Trust Ready

### Explore the architecture

## Build your next application on data that connects.

Bring your custom data models and business operations together with HTQLDB.

- [Build with HTQLDB](https://sigmar.au/pricing)
- [Book a Demo](https://sigmar.au/book-demo)
