#601

Global Rank · of 601 Skills

turso AI Agent Skill

View Source: oakoss/agent-skills

Safe

Installation

npx skills add oakoss/agent-skills --skill turso

34

Installs

Turso

Overview

Turso is an edge-hosted SQLite platform built on libSQL, an open-source fork of SQLite. It provides globally distributed databases with embedded replicas for local-first reads, a platform API for programmatic database management, and native vector search. Use Turso for edge-deployed applications needing low-latency reads, per-tenant database isolation, or offline-capable embedded replicas. Avoid when you need a traditional relational database with complex joins across tenants or require PostgreSQL-specific features.

Quick Reference

Pattern API / Command Key Points
Remote client createClient({ url, authToken }) Connect to Turso cloud database
Local file client createClient({ url: 'file:local.db' }) Pure local SQLite via libSQL
Embedded replica createClient({ url, syncUrl, authToken }) Local reads, remote sync
Manual sync client.sync() Pull latest changes from remote
Periodic sync syncInterval: 60 in client config Auto-sync interval in seconds
Execute query client.execute({ sql, args }) Positional ? or named $param args
Batch operations client.batch([...statements], mode) Atomic multi-statement execution
Interactive transaction client.transaction('write') Multi-step logic with commit/rollback
Encryption at rest encryptionKey in client config Encrypts local database file
Vector insert vector32('[0.1, 0.2, ...]') Store embeddings as F32_BLOB columns
Vector search vector_distance_cos(col, vector32(...)) Cosine similarity, ORDER BY distance ASC
Vector index libsql_vector_idx(col, 'type=diskann') DiskANN index for efficient nearest-neighbor
Create database (CLI) turso db create <name> Provision new database
Create database (API) POST /v1/organizations/{org}/databases Programmatic provisioning for multi-tenant
Generate token (CLI) turso db tokens create <name> Auth tokens with optional read-only and expiration
Drizzle integration drizzle(createClient({ url, authToken })) Use drizzle-orm/libsql driver
In-memory database createClient({ url: ':memory:' }) Ephemeral database for testing

Common Mistakes

Mistake Correct Pattern
Using syncUrl without authToken Embedded replicas require both syncUrl and authToken
Forgetting client.sync() before reads Call sync() or set syncInterval to keep replica current
Using vector_distance_cos without a vector index Create a libsql_vector_idx index for efficient similarity search
Hardcoding auth tokens in source code Use environment variables for TURSO_DATABASE_URL and TURSO_AUTH_TOKEN
Using interactive transactions for simple batches Use client.batch() for atomic multi-statement operations
Not closing transactions on error Always call transaction.close() in a finally block
Creating one database for all tenants Use multi-database per-tenant isolation for SaaS workloads
Passing raw arrays as vector values Wrap vectors with vector32() SQL function or pass as Float32Array
Using ORDER BY distance DESC for nearest neighbor Cosine distance: smaller is closer, use ORDER BY distance ASC

Delegation

If the drizzle-orm skill is available, delegate ORM schema definition, query building, relations, and migration patterns to it.
Otherwise, recommend: pnpm dlx skills add oakoss/agent-skills -s drizzle-orm -a claude-code -y

If the local-first skill is available, delegate architecture decisions, sync engine comparisons, and conflict resolution strategies to it.
Otherwise, recommend: pnpm dlx skills add oakoss/agent-skills -s local-first -a claude-code -y

If the pglite skill is available, delegate PGlite-specific patterns for comparison with Turso embedded replicas.

  • Database provisioning: Use Task agent for multi-tenant setup automation
  • Vector search tuning: Use Explore agent to research embedding models and dimensions
  • Code review: Delegate to code-reviewer agent

References

Installs

Installs 34
Global Rank #601 of 601

Security Audit

ath Safe
socket Safe
Alerts: 0 Score: 90
snyk Low
EU EU-Hosted Inference API

Power your AI Agents with the best open-source models.

Drop-in OpenAI-compatible API. No data leaves Europe.

Explore Inference API

GLM

GLM 5

$1.00 / $3.20

per M tokens

Kimi

Kimi K2.5

$0.60 / $2.80

per M tokens

MiniMax

MiniMax M2.5

$0.30 / $1.20

per M tokens

Qwen

Qwen3.5 122B

$0.40 / $3.00

per M tokens

How to use this skill

1

Install turso by running npx skills add oakoss/agent-skills --skill turso in your project directory. Run the install command above in your project directory. The skill file will be downloaded from GitHub and placed in your project.

2

No configuration needed. Your AI agent (Claude Code, Cursor, Windsurf, etc.) automatically detects installed skills and uses them as context when generating code.

3

The skill enhances your agent's understanding of turso, helping it follow established patterns, avoid common mistakes, and produce production-ready output.

What you get

Skills are plain-text instruction files — not executable code. They encode expert knowledge about frameworks, languages, or tools that your AI agent reads to improve its output. This means zero runtime overhead, no dependency conflicts, and full transparency: you can read and review every instruction before installing.

Compatibility

This skill works with any AI coding agent that supports the skills.sh format, including Claude Code (Anthropic), Cursor, Windsurf, Cline, Aider, and other tools that read project-level context files. Skills are framework-agnostic at the transport level — the content inside determines which language or framework it applies to.

Data sourced from the skills.sh registry and GitHub. Install counts and security audits are updated regularly.

EU Made in Europe

Chat with 100+ AI Models in one App.

Use Claude, ChatGPT, Gemini alongside with EU-Hosted Models like Deepseek, GLM-5, Kimi K2.5 and many more.

Start for free View pricing
Customer Support