execsql
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. Data can be exported in 18 different formats, including CSV, TSV, ODS, HTML, JSON, LaTeX, and Markdown tables, and using custom templates.
Ecosystem
pypi.org
pypi.org
Latest Release
over 1 year ago
1.130.1
over 1 year ago
Versions
195
195
Downloads
1,659 last month
1,659 last month
Dependent Repos
3
3
Links
| Registry | pypi.org |
| Homepage | Homepage |
| Docs | Documentation |
| JSON API | View JSON |
| CodeMeta | codemeta.json |
Package Details
| PURL |
pkg:pypi/execsql
spec |
| License | GPL-2.0+ |
| First Release | over 8 years ago |
| Last Synced | 6 days ago |
Keywords
SQL Postgres PostgreSQL SQLite Firebird Access SQL Server MySQL MariaDb ODBC Oracle DuckDB database xlrd psycopg2 pyodbc pymysql fdb cx_Oracle cx-Oracle odfpy ETL CSV TSV XML HTML JSON Feather LaTeX OpenDocument table DBMS Redshift CockroachDB query script import export Parquet template Jinja Airspeed zip
SQL Postgres PostgreSQL SQLite Firebird Access SQL Server MySQL MariaDb ODBC Oracle DuckDB database xlrd psycopg2 pyodbc pymysql fdb cx_Oracle cx-Oracle odfpy ETL CSV TSV XML HTML JSON Feather LaTeX OpenDocument table DBMS Redshift CockroachDB query script import export Parquet template Jinja Airspeed zip
Rankings on pypi.org
Dependent repos
Top 9.0%