skills.rest
mikkelkrogsholm
mikkelkrogsholmCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

dst-list-tables

List local DuckDB DST tables with metadata in console or JSON.

2|1|Updated Oct 30, 2025
Search Tags:#metadata#query#local#inventory#tables#dst
One-click install
npx skills add https://github.com/mikkelkrogsholm/dst-skills --skill dst-list-tables
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dst-list-tables
Source: https://github.com/mikkelkrogsholm/dst-skills/tree/main/.claude/skills/dst-list-tables
Command: npx skills add https://github.com/mikkelkrogsholm/dst-skills --skill dst-list-tables

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

Quickly assessing what data you have locally empowers faster analysis planning and ensures data availability.

Core Features & Use Cases

  • Local inventory: List all locally stored DST tables with counts and ages.
  • Metadata depth: Retrieve per-table metadata and sample rows for quick validation.
  • Format options: Console view or JSON for programmatic use.

Quick Start

python scripts/db/query_metadata.py --list-all --format json

Frequently Asked Questions about dst-list-tables

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

FAQPage Schema
How do I list all tables stored in my local DuckDB database?▼

List all local DuckDB tables by running `python scripts/db/query_metadata.py --list-all`. This queries your local metadata and outputs table inventory with record counts, last update timestamps, and age—available in console or JSON format for programmatic access.

What metadata can I retrieve about my stored DST tables?▼

Per-table metadata includes table_id, table_name, record_count, last_updated, fetch_timestamp, and age. The Skill queries local DuckDB metadata to surface this information alongside sample rows, enabling quick validation of data freshness and availability before analysis.

Can I export my table inventory as JSON instead of viewing it in the console?▼

Yes. Use the `--format json` flag with `python scripts/db/query_metadata.py --list-all --format json` to output your table metadata as structured JSON, making it suitable for downstream programmatic workflows and integration.

How do I verify that my locally cached DST tables are fresh before running analysis?▼

List your tables with metadata output to check the last_updated and age fields for each table. This Skill retrieves these timestamps from local DuckDB metadata, letting you assess data currency and plan your analysis accordingly without manual inspection.

What's the fastest way to discover what data I have available locally?▼

Run `python scripts/db/query_metadata.py --list-all` to quickly inventory all locally stored DST tables with counts and ages. This single command surfaces your complete local data catalog and identifies what's available before committing to analysis workflows.

Do I need any external dependencies to list my local DST tables?▼

No external dependencies are required. The Skill uses Python tooling to query your local DuckDB metadata directly, producing console and JSON outputs without additional setup or third-party tools.

Related Skills

Explore More Data & Analytics Skills→
mikkelkrogsholmmikkelkrogsholm
2

dst-data

Fetch Danmarks Statistik API data into a local DuckDB table named dst_<table_id>.

Community
Intermediate
hoanghn61hoanghn61

report_exporter

Converts TechStackReport JSON into Markdown, HTML, and PDF exports.

Community
Intermediate
robdmcrobdmc

duckdb-sql

Generate DuckDB SQL queries from plain English questions using asset schemas.

Community
Advanced
ScottHMcKeanScottHMcKean

databricks-genie

Create and query Databricks Genie Spaces for natural language SQL exploration.

Community
Intermediate