SQLite Data Studio

SQLite Data Studio is the wiki's database environment: an administration surface in the style of Azure Data Studio — object explorer, table designer, query workbench, data browser and export — and beneath it an API for named SQL routines that other packages call. It is meant for operators who inspect, query and export data, and for plugin developers who want SQL out of their code.

Getting started

Enable the studio → create a connection → browse the objects → run a query

Common tasks

What you want	For whom	Where you do it	Instructions
open the studio	operators	Admin > SQLite Data Studio	Reference: enabling (German)
create a named connection	operators	studio, “Connect to…” dialog	Reference: connections (German)
inspect or change a table	operators	studio, object explorer	Reference: studio (German)
write and run a query	operators	studio, query workbench	Reference: query workbench (German)
create an SQL routine	developers	a `.sql` file and manifest in your own package	Reference: recipes (German)
grant access to a non-superuser	operators	studio, capability matrix	Reference: permissions (German)

For developers

Technical reference of the package (German)
API reference (German) – execute, registerSet, getConnection, testConnection
wkcore – the registry through which the sql.routines service is found

The full technical reference for this package is currently available in German only.