query-cli

name	query-cli
description	Use this skill to query parsed Excel data using the eparse CLI. Call when you need to analyze, filter, or summarize data stored in SQLite or PostgreSQL databases created by eparse.
license	MIT

Query Parsed Data with eparse CLI

When to use

• To analyze, filter, or summarize data extracted from Excel files and stored in a database.
• For reporting, data validation, or extracting subsets of data.

How to use

1. Query distinct column headers:

   eparse -i sqlite3:///.files/mydb.db -o stdout:/// query -m get_c_header
   

2. Query all data (untruncated):

   eparse -t -i sqlite3:///.files/mydb.db -o stdout:/// query
   

3. Filter data (e.g., by file name):

   eparse -i sqlite3:///.files/mydb.db -o stdout:/// query --filter f_name "somefile.xlsx"
   

• Replace sqlite3:///.files/mydb.db with your database URI. PostgreSQL is also supported.
• See README for filter options and advanced usage.