ck_query_sql
Run read-only SQL SELECT queries against Credit Karma transaction data to retrieve or aggregate transactions, accounts, categories, and merchants. Supports CTEs and LIMIT/OFFSET paging.
Instructions
Execute a raw SQL SELECT query (CTEs via WITH ... SELECT are supported) against the transactions database. Non-SELECT statements (INSERT, UPDATE, DELETE, DROP, etc.) are rejected. Returns at most max_rows rows (default 500, max 5000); a larger result comes back with truncated: true, so prefer aggregates or LIMIT/OFFSET paging. A query running longer than 10 s is stopped. Only the first statement runs. Tables: transactions, accounts, categories, merchants, sync_state.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | A SELECT SQL statement | |
| max_rows | No | Most rows to return (default 500). Page larger results with LIMIT/OFFSET. |