Skip to main content

Documentation Index

Fetch the complete documentation index at: https://mintlify.com/felixdotgo/querybox/llms.txt

Use this file to discover all available pages before exploring further.

QueryBox supports SQLite databases through a native driver plugin. Connect to local SQLite database files or cloud-hosted databases like Turso.

​
Connection Methods

Connect to a local SQLite database file:
​
file
string
required
Path to the SQLite database fileExample: /path/to/database.db

​
Example

/Users/username/projects/myapp/database.db

​
Connection String Examples

​
Relative Path

./data/app.db

​
Absolute Path

/var/lib/myapp/database.sqlite3

​
In-Memory Database

:memory:

​
Turso with Authentication

libsql://example.turso.io?authToken=your-token-here

​
Supported Features

SQL Queries

Execute SELECT, INSERT, UPDATE, DELETE statements

Query Explanation

Analyze query execution plans with EXPLAIN

Table Browser

Browse all tables in the database

DDL Operations

Create and drop tables

​
Capabilities

  • Query Execution: Run SELECT queries and view results in table format
  • DDL Support: Execute CREATE, DROP, ALTER statements
  • DML Support: INSERT, UPDATE, DELETE operations
  • Explain Query: Analyze query execution plans
  • Connection Tree: Browse all tables with quick-access actions
  • PRAGMA Support: Execute SQLite PRAGMA statements
  • Cloud Support: Connect to Turso cloud databases (non-Windows only)

​
Special Query Handling

The SQLite plugin intelligently detects query types:
  • SELECT/WITH/PRAGMA: Returns result rows
  • DDL/DML statements: Executes without returning rows (CREATE, DROP, INSERT, UPDATE, DELETE)
Non-SELECT statements use db.Exec() instead of db.Query() to properly handle operations that don’t return rows.

​
Database Structure

The SQLite plugin displays a flat list of tables:
  • Tables: All user-created tables (queries sqlite_master)
  • Actions: Quick SELECT and DROP operations for each table

​
Notes

SQLite is serverless and file-based, making it perfect for embedded applications, local development, and testing.
Ensure the application has read/write permissions to the database file and its parent directory.

​
Turso Cloud

Turso is a cloud-hosted SQLite platform built on libsql. Benefits include:
  • Global replication
  • Edge deployment
  • Built-in authentication
  • Scales to thousands of databases
Learn more about Turso at turso.tech

​
Plugin Information

  • Version: 0.1.0
  • License: Public Domain
  • Author: SQLite Consortium
  • Tags: sql, relational
  • Driver: modernc.org/sqlite (pure Go implementation)

Build docs developers (and LLMs) love

Get started for freeTalk to us