{"id":2727540,"name":"execsql","ecosystem":"pypi","description":"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.","homepage":"https://osdn.net/project/execsql/","licenses":"GPL","normalized_licenses":["GPL-2.0+"],"repository_url":null,"keywords_array":["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"],"namespace":null,"versions_count":195,"first_release_published_at":"2017-05-28T16:19:43.000Z","latest_release_published_at":"2024-09-28T23:12:07.000Z","latest_release_number":"1.130.1","last_synced_at":"2026-04-20T14:31:33.707Z","created_at":"2022-04-10T10:56:03.027Z","updated_at":"2026-04-20T14:33:29.395Z","registry_url":"https://pypi.org/project/execsql/","install_command":"pip install execsql --index-url https://pypi.org/simple","documentation_url":"https://execsql.readthedocs.io/","metadata":{"funding":null,"documentation":null,"classifiers":["Development Status :: 5 - Production/Stable","Environment :: Console","Environment :: Win32 (MS Windows)","Environment :: X11 Applications","Intended Audience :: End Users/Desktop","Intended Audience :: Information Technology","Intended Audience :: System Administrators","License :: OSI Approved :: GNU General Public License (GPL)","Natural Language :: English","Operating System :: Microsoft :: Windows","Operating System :: OS Independent","Operating System :: POSIX","Programming Language :: Python :: 2","Programming Language :: Python :: 2.7","Programming Language :: Python :: 3","Topic :: Database","Topic :: Database :: Front-Ends","Topic :: Office/Business","Topic :: Scientific/Engineering"],"normalized_name":"execsql","project_status":null},"repo_metadata":{},"repo_metadata_updated_at":"2026-04-20T14:33:29.373Z","dependent_packages_count":0,"downloads":1144,"downloads_period":"last-month","dependent_repos_count":3,"rankings":{"downloads":12.29801425181804,"dependent_repos_count":9.031485896481191,"dependent_packages_count":9.966767819241568,"stargazers_count":null,"forks_count":null,"docker_downloads_count":null,"average":10.4320893225136},"purl":"pkg:pypi/execsql","advisories":[],"docker_usage_url":"https://docker.ecosyste.ms/usage/pypi/execsql","docker_dependents_count":null,"docker_downloads_count":null,"usage_url":"https://repos.ecosyste.ms/usage/pypi/execsql","dependent_repositories_url":"https://repos.ecosyste.ms/api/v1/usage/pypi/execsql/dependencies","status":null,"funding_links":[],"critical":null,"issue_metadata":null,"versions_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/execsql/versions","version_numbers_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/execsql/version_numbers","dependent_packages_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/execsql/dependent_packages","related_packages_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/execsql/related_packages","codemeta_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/packages/execsql/codemeta","maintainers":[{"uuid":"rdnielsen","login":"rdnielsen","name":null,"email":null,"url":null,"packages_count":11,"html_url":"https://pypi.org/user/rdnielsen/","role":null,"created_at":"2022-11-18T04:07:44.620Z","updated_at":"2022-11-18T04:07:44.620Z","packages_url":"https://packages.ecosyste.ms/api/v1/registries/pypi.org/maintainers/rdnielsen/packages"}]}