Live Playground

Try SQLSpec directly in your browser. The playground runs a sandboxed Python runtime using WebAssembly and an in-memory SQLite database.

Python

Usage tips Run Reset

from sqlspec import SQLSpec from sqlspec.adapters.sqlite import SqliteConfig spec = SQLSpec() config = spec.add_config(SqliteConfig(connection_config={"database": ":memory:"})) with spec.provide_session(config) as session: session.execute("CREATE TABLE IF NOT EXISTS teams (id INTEGER PRIMARY KEY, name TEXT)") session.execute("INSERT INTO teams (name) VALUES ('Litestar'), ('SQLSpec')") result = session.select("SELECT * FROM teams") # Return list of dictionaries for table rendering print(result)

Output Clear

Usage Tips

• Run the default snippet to seed a SQLite in-memory database.
• Edit the Python code to try different SQLSpec features.
• SQL keywords are highlighted in the code editor.
• Return a list of dictionaries to see a results table.
• Reset restores the default snippet.

Close