turso-dblisted
Install: claude install-skill av/skills
# Turso DB
Turso is an in-process relational database engine aiming for full SQLite compatibility. Unlike client-server databases, it runs in your application's memory space with sub-microsecond read/write latencies.
## Installation
```bash
# Via installer script
curl --proto '=https' --tlsv1.2 -LsSf \
https://github.com/tursodatabase/turso/releases/latest/download/turso_cli-installer.sh | sh
# Via Homebrew
brew install turso
```
## Quick Start
```console
$ tursodb # transient in-memory database
$ tursodb mydata.db # persistent database file
```
```sql
CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, email TEXT);
INSERT INTO users VALUES (1, 'Alice', 'alice@example.com');
SELECT * FROM users;
```
## Core SQL
Standard SQLite-compatible SQL. See [references/sql-reference.md](references/sql-reference.md) for full statement syntax (CREATE/ALTER/DROP TABLE, INSERT, SELECT, UPDATE, DELETE, transactions).
Key differences from SQLite:
- No multi-process/multi-threading access
- No savepoints, triggers, or vacuum
- Views experimental (behind `--experimental-views` flag)
- UTF-8 only
## JavaScript API
Install and use from Node.js:
```bash
npm i @tursodatabase/database # native
npm i @tursodatabase/database --cpu wasm32 # WASM
```
```javascript
import { connect } from '@tursodatabase/database';
const db = await connect('turso.db');
const row = db.prepare('SELECT 1').get();
```
See [references/javascript-api.md](reference