# Resta

> Open-source, self-hosted server for many small SQL databases, one per user, tenant or agent. One Docker Compose file, Coolify-ready, Turso-compatible.

Key facts:

- License: MIT. Self-hosted only; there is no hosted Resta service.
- Runs from one Docker Compose file (gateway, dashboard, api, node, postgres); ready for Coolify.
- One account (super user) per server, plus API keys and expiring database tokens.
- Databases use the SQLite dialect and file format, on the Turso engine; Turso SQL over HTTP v3 protocol.
- Tested client: @tursodatabase/serverless (JavaScript). Not affiliated with Turso.
- Backups: hourly snapshots of changed databases, 72 kept, to a Docker volume or any S3-compatible bucket.
- Status: pre-release; the source repository is not public yet.

Full documentation as one file: https://resta.dev/llms-full.txt

## Start

- [What is Resta](https://resta.dev/docs/introduction.md): A self-hosted server for many small SQL databases, and when to use it.
- [Quickstart](https://resta.dev/docs/quickstart.md): From a running server to your first query in five minutes.

## Install

- [Install on Coolify](https://resta.dev/docs/install-coolify.md): Deploy Resta as a Docker Compose resource on Coolify.
- [Install with Docker Compose](https://resta.dev/docs/install-docker.md): Run Resta on any server with Docker, with automatic TLS.
- [Configuration](https://resta.dev/docs/configuration.md): Every environment variable, with its default.

## Use

- [HTTP API](https://resta.dev/docs/api.md): Create databases, issue tokens, manage keys and backups over HTTP.
- [Connecting from code](https://resta.dev/docs/clients.md): Query a Resta database with the Turso JavaScript client or plain HTTP.
- [SQL support and limits](https://resta.dev/docs/sql.md): The SQLite dialect, blocked statements, and resource limits.
- [Backups and restore](https://resta.dev/docs/backups.md): Hourly snapshots to a volume or any S3-compatible bucket, and how to restore.

## Operate

- [Upgrading](https://resta.dev/docs/upgrading.md): Move to a new version and what to expect while it restarts.
- [Security](https://resta.dev/docs/security.md): What is exposed, how credentials work, and how to use tokens safely.
- [Architecture](https://resta.dev/docs/architecture.md): The five services, how requests flow, and where data lives.
- [FAQ](https://resta.dev/docs/faq.md): Common questions about Resta, Turso, SQLite and self-hosting.