skills.rest
karimStekelenburg
karimStekelenburgCOMMUNITY
Explore all skills by this author →
𝕏@ssi_karimGitHub

view-data

Launch a datasette dashboard or print a summary of personal finance database records.

Updated Mar 19, 2026
Search Tags:#sqlite#invoices#transactions#datasette#payment status#finance dashboard#data viewer
One-click install
npx skills add https://github.com/karimStekelenburg/k3m-marketplace --skill view-data-karimstekelenburg
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: view-data
Source: https://github.com/karimStekelenburg/k3m-marketplace/tree/main/plugins/personal-finance/skills/view-data
Command: npx skills add https://github.com/karimStekelenburg/k3m-marketplace --skill view-data-karimstekelenburg

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires datasette, uv, and includes scripts (resource) components.

What problem does it solve? Reviewing invoices, bank transactions, and payment matches stored in a local finance database requires manual SQL work or ad-hoc queries. This Skill opens the entire dataset in an interactive browser UI or prints a quick text summary. ## Core Features & Use Cases - Interactive Data Browser: Launches a datasette instance at http://localhost:8001 exposing the invoices, transactions, matches, emails, and qr_codes tables with full search and filtering. - Text Summary Mode: The --summary-only flag prints a formatted overview of payment status directly to the terminal instead of starting a server. - Unpaid Invoice Lookup: Provides a ready-made SQL query to isolate invoices without confirmed transaction matches in the datasette query editor. - Use Case: After importing a batch of invoices, ask to view the finance dashboard to verify which invoices remain unpaid and inspect low-confidence matches. ## Quick Start Ask the assistant to open the finance dashboard so you can browse all invoices and check their payment status in the browser.

Frequently Asked Questions about view-data

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I view all my invoices and transactions in a browser?▼

Run the view-data skill, which starts a datasette server at http://localhost:8001. Open that URL to browse the invoices, transactions, matches, emails, and qr_codes tables with built-in search and filtering.

How do I find unpaid invoices with SQL in datasette?▼

Open datasette, go to the top-right menu, choose Execute SQL, and run: SELECT * FROM invoices WHERE id NOT IN (SELECT invoice_id FROM matches WHERE confidence != 'review'). This returns invoices lacking a confirmed transaction match.

Can I get a quick payment summary without launching a web server?▼

Yes, pass the --summary-only flag. The script prints a formatted text summary of the finance data to stdout instead of starting datasette, and the output is displayed verbatim.

What happens if datasette port 8001 is already in use?▼

The skill shows the raw error from the script. You should stop the existing datasette process occupying the port, or specify an alternate port if the script supports one.

Can I point the viewer at a different finance data directory?▼

Yes, use the --data-dir argument to specify a custom path. Without it, the skill defaults to ~/Documents/finance-data/ as the data directory.

Related Skills

Explore More Finance & Accounting Skills→
Tres-Finance-PublicTres-Finance-Public

tres-invoice-bill-matching

Match TRES ledger transactions to ERP invoices or bills.

Official
Intermediate
anthropicsanthropics
23.8k

invoice-chase

Drafts tone-matched overdue invoice reminders from QuickBooks and PayPal data.

Official
Advanced
wangzitian0wangzitian0

reconciliation

Matches bank statement transactions to ledger entries using configurable scoring.

Community
Advanced
drvossdrvoss
42

session-management

Track multi-step tasks and state across sessions using SQLite tables.

Community
Intermediate