sql
Run read-only SQL queries on your local AnkiWeb database for ad-hoc analysis, aggregations, and joins across synced resources. Requires sync first.
Instructions
Run read-only SQL against local database. Use for ad-hoc analysis, aggregations, and joins across synced resources. Requires sync first.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | SQL query (SELECT or WITH...SELECT). Synced records live in resources(resource_type, id, data); filter by resource_type and use json_extract on data, e.g. SELECT json_extract(data,'$.name') FROM resources WHERE resource_type='card'. |