7 projects
execsql2
Runs a SQL script against a PostgreSQL, SQLite, MariaDB/MySQL, DuckDB, Firebird, MS-Access, MS-SQL-Server, or Oracle database, or an ODBC DSN. Provides metacommands to import and export data, copy data between databases, conditionally execute SQL and metacommands, and dynamically alter SQL and metacommands with substitution variables.
crosstab
Rearrange data from a normalized CSV format to a crosstabulated format, with styling.
pg-upsert
A Python library for validating and upserting data into PostgreSQL with automated QA checks.
vitalog
Health data CLI — ETL Apple Health & SleepCycle into DuckDB, generate AI narratives, and build interactive dashboards.
casquery
Search Chemical Abstracts Service Registry Numbers (CASRNs) from the EPA Substance Registry Services (SRS) database.
crossdb-query
Execute a SQL file on all PostgreSQL databases on a host.
pg-summary
Create a summary of unique values for each column in a Postgres table or view and summarize results in an Excel workbook.
