Can I run Turso tests in memory?

Yes, the skill recommends using :memory: (for .sqltest) or {:memory:} (for TCL) to ensure tests are fast and do not leave persistent data artifacts.

What is the preferred test format for Turso?

The .sqltest format is the modern standard for Turso, as it allows the same test cases to run against various backends like the CLI and Rust bindings.

Where should I add new SQL compatibility tests?

New SQL compatibility tests should be added as .sqltest files located within the turso-test-runner/tests/ directory.

How do I convert old TCL tests to the new format?

Use the convert command within the turso-test-runner to automate most of the transition, then manually verify outputs to account for seed-based differences.

How do I enable detailed logging for debugging tests?

You can set the RUST_LOG environment variable (e.g., RUST_LOG=none,turso_core=trace) when running make test to see verbose output in testing/system/test.log.

Turso Database Testing

Name: Turso Database Testing
Author: tursodatabase

bytursodatabase

•

17,108

Security & Testing

Streamlines the creation, conversion, and execution of SQL-compatible tests for the Turso database environment.

About

This skill provides comprehensive guidance for testing within the Turso database ecosystem, enabling developers to maintain high-quality code through standardized testing patterns. It specifically facilitates the transition from legacy TCL .test files to the modern .sqltest format, which supports cross-backend execution. Whether you are writing Rust integration tests, fuzzing complex features, or verifying SQL compatibility, this skill ensures you follow established best practices, use the correct test runners, and leverage in-memory database configurations for fast, isolated verification.

Key Features

17,108 GitHub stars
Standardized patterns for SQL compatibility, Rust integration, and fuzz testing
Advanced debugging support with verbose logging and trace configurations
Migration workflows for converting legacy TCL tests to the modern .sqltest format
Automated test execution commands for TCL, Rust, and SQL runners
Best practices for in-memory database testing to ensure speed and isolation

Use Cases

Migrating existing SQLite-compatible TCL tests to Turso's universal .sqltest format
Implementing regression tests for complex database features using Rust integration suites
Verifying SQL compatibility across multiple backends including CLI and Rust bindings

About

Key Features

17,108 GitHub stars
Standardized patterns for SQL compatibility, Rust integration, and fuzz testing
Advanced debugging support with verbose logging and trace configurations
Migration workflows for converting legacy TCL tests to the modern .sqltest format
Automated test execution commands for TCL, Rust, and SQL runners
Best practices for in-memory database testing to ensure speed and isolation

Use Cases

Migrating existing SQLite-compatible TCL tests to Turso's universal .sqltest format
Implementing regression tests for complex database features using Rust integration suites
Verifying SQL compatibility across multiple backends including CLI and Rust bindings