tursodatabase/turso
13 skills10.1k installs305k starsGitHub
Install
npx skills add https://github.com/tursodatabase/tursoSkills in this repo
1Code Qualitycode-quality is an agent skill from tursodatabase/turso that general correctness rules, rust patterns, comments, avoiding over-engineering. when writing code always take these into account. # Code Quality Guide ## Core Principle Production database. Correctness paramount. Crash > corrupt. ## Correctness Rules 1. **No workarounds or quick hacks.** Handle all errors, check invariants 2. **Assert often.** Never silently fail or swallow edge cases 3. **Crash on invalid state** if it risks data integrity. Don't continue in undefined st Developers invoke code-quality during build/integrations work for ai & agent building tasks. The skill documents triggers, prerequisites, and step-by-step workflows grounded in SKILL.md. Compatible with Claude Code, Cursor, and Codex agent runtimes that load marketplace skills. Review the Security Audits panel on this listing before installing in production environments.1.4kinstalls2Index Knowledgeindex-knowledge is a Turso-repo skill that builds a hierarchical AGENTS.md knowledge base for Claude, Cursor, and other coding agents. It runs discovery and analysis concurrently—parallel explore agents, bash structure inspection, LSP codemap reads, and review of existing AGENTS.md—then writes a root file plus complexity-scored subdirectory docs. Default mode updates existing files and adds new ones where warranted; --create-new wipes and regenerates from scratch, and --max-depth limits traversal (default depth 5). Developers reach for index-knowledge when a growing monorepo or deep tree outpaces hand-maintained agent context and they want agents to reason about layout, hotspots, and ownership without re-exploring every session.1kinstalls3Debuggingdebugging is a Turso project skill for systematically diagnosing when tursodb behavior diverges from SQLite. The documented workflow compares EXPLAIN bytecode between sqlite3 and cargo-run tursodb binaries, branching diagnosis toward code-generation bugs when bytecode differs or VM and storage-layer bugs when bytecode matches but results differ. The guide covers manual query inspection via cargo run --bin tursodb, ThreadSanitizer instrumentation, deterministic simulation, and corruption analysis tooling. Developers reach for debugging when migrating SQLite workloads to Turso, writing compatibility-sensitive SQL, or investigating query result mismatches in Rust-backed database development.981installs4Async Io Modelasync-io-model is a Turso database skill describing the engine's cooperative asynchronous I/O model used in the Rust core instead of async/await. Functions return IOResult with Done or IO variants and must be called repeatedly until completion, coordinating through Completion and CompletionGroup types. The guide covers re-entrancy pitfalls and mandates these patterns for any IO work inside tursodb core. Developers contributing to Turso or embedding its engine reach for async-io-model before writing storage, network, or syscall paths that must yield cooperatively. The skill prevents subtle bugs from mixing conventional Rust async with Turso's explicit state-machine I/O loop. Treat async-io-model as required reading for core patches touching IOResult-returning functions.950installs5Storage Formatstorage-format is a Turso database skill documenting the SQLite 3 on-disk file layout used by tursodb. It maps the 100-byte database header, B-tree page structure, cell and overflow pages, and freelist mechanics, with default page size 4096 bytes and supported sizes from 512 to 65536 bytes as powers of two. Developers use storage-format when diagnosing slow queries, reasoning about index layout, estimating storage overhead, or extending Turso with format-aware tooling. The skill is reference depth for physical storage, not a migration or ORM tutorial.946installs6Testingtesting is the Turso database engine testing guide for contributors who must prove SQL compatibility before merging changes. The skill prioritizes new .sqltest files under testing/sqltests/tests/, explains when to keep legacy TCL .test files in testing/, and covers Rust integration tests in tests/integration/ plus fuzz targets in tests/fuzz/ for edge-case discovery. Developers converting .test to .sqltest get migration guidance because TCL tests are being phased out. Reach for testing when adding SQL compat cases, debugging failing engine tests, or running the full Turso test suite locally during database engine development.945installs7Pr Workflowpr-workflow is a Turso-published agent skill outlining general guidelines for commits, formatting, CI, dependencies, and security when AI agents contribute to a repository. It mandates atomic commits that separate logic from formatting, encourages git rebase -i for clean history, and keeps pull requests small with relevant tests run before submission. The skill documents GitHub Action constraints such as max-turn limits in .github/workflows/claude.yml and allows WIP commits or WIP PRs when continuing across actions. Developers reach for pr-workflow when agent-assisted changes risk noisy diffs, mixed concerns, or unsafe dependency updates before merge.928installs8Transaction Correctnesstransaction-correctness is a reference skill from tursodatabase/turso that documents how Turso's exclusive Write-Ahead Logging (WAL) model handles commits, reads, checkpoints, and recovery. Turso stores data in `.db` and `.db-wal` files and uses an in-memory WAL index instead of a `.db-shm` shared-memory file. The guide walks through the write path where writers append frames and COMMIT marks the transaction end, plus the read path where readers acquire a read mark and merge WAL frames with the main database for a consistent snapshot. Developers reach for transaction-correctness when implementing concurrent writers, diagnosing stale reads, or reasoning about checkpoint timing in embedded Turso deployments.925installs9Differential Fuzzerdifferential-fuzzer is a Turso repository skill that explains how to run the differential oracle fuzzer located at testing/differential-oracle/fuzzer/. The tool generates random SQL—default 100 statements per basic cargo run—and compares Turso results to SQLite to find correctness bugs, with flags for --seed reproducibility and verbose output. Developers reach for it when validating database engine changes or investigating suspected SQL semantic drift. The skill directs agents to load the related Turso debugging skill alongside fuzzer runs for triage context.916installs10Mvccmvcc is a Turso repository skill describing the experimental Multi-Version Concurrency Control feature, explicitly marked work in progress and not production-ready. It explains enabling MVCC per database at runtime with PRAGMA journal_mode = 'mvcc', contrasting WAL's single page version with MVCC's multiple row versions and snapshot isolation at transaction begin time. Developers reach for it when experimenting with concurrency models or debugging MVCC-specific bugs—the skill warns to ignore MVCC unless the issue is MVCC-related. It suits engine contributors and advanced users evaluating isolation semantics before any production adoption.916installs11CdcCDC skill for tursodatabase/turso explains how to enable change-data capture on Turso SQLite: define streams, handle insert/update/delete events, connect webhooks or pipelines, and design idempotent consumers for search indexes, warehouses, and agent context sync.133installs12Memory Benchmarkmemory-benchmark is a Claude Code skill for ai & agent building. It helps solo builders move faster with AI-assisted development.37installs13Yield Injectionsyield-injections is a Claude Code skill for ai & agent building. It helps solo builders move faster with AI-assisted development.20installs