usql - universal command-line interface for SQL databases

  •        51

usql is a universal command-line interface for PostgreSQL, MySQL, Oracle, SQLite3, Microsoft SQL Server, and other databases.The below is a demonstration using usql with xo's booktest simple test database, showcasing the release version v0.5.0. In the demonstration, usql connects to a PostgreSQL database, executes some queries, with variable interpolation, connects to a SQLite3 database file, and does some more queries, before then connecting to a Microsoft SQL database and ending the session.

https://github.com/xo/usql

Tags
Implementation
License
Platform

   




Related Projects

sqlcheck - Automatically identify anti-patterns in SQL queries


sqlcheck automatically detects common SQL anti-patterns. Such anti-patterns often slow down queries. Addressing them will, therefore, help accelerate queries.sqlcheck targets all major SQL dialects.

dburl - Package dburl provides a standard, URL style mechanism for parsing and opening SQL database connection strings


Package dburl provides a standard, URL style mechanism for parsing and opening SQL database connection strings for Go, supporting standard URLs for the standard databases PostgreSQL, MySQL, SQLite3, Oracle, Microsoft SQL Server, and most other databases with a publicly available Go driver.* for Microsoft SQL Server, the syntax to supply an instance and database name is /instance/dbname, where /instance is optional. For Oracle databases, /dbname is the unique database ID (SID). Please see below for examples.

go-queryset - 100% type-safe ORM for Go (Golang) with code generation and MySQL, PostgreSQL, Sqlite3, SQL Server support


100% type-safe ORM for Go (Golang) with code generation and MySQL, PostgreSQL, Sqlite3, SQL Server support. GORM under the hood.Take a loot at line // gen:qs. It's a necessary line to enable querysets for this struct. You can put it at any line in struct's doc-comment.

sql-xplat-cli - Repository for the new SQL cross-platform command line tools


We’re excited to introduce mssql-scripter, a multi-platform command line experience for scripting SQL Server databases.mssql-scripter is the multiplatform command line equivalent of the widely used Generate Scripts Wizard experience in SSMS. You can use mssql-scripter on Linux, macOS, and Windows to generate data definition language (DDL) and data manipulation language (DML) T-SQL scripts for database objects in SQL Server running anywhere, Azure SQL Database, and Azure SQL Data Warehouse. You can save the generated T-SQL script to a .sql file or pipe it to standard nix utilities (for example, sed, awk, grep) for further transformations. You can edit the generated script or check it into source control and subsequently execute the script in your existing SQL database deployment processes and DevOps pipelines with standard multiplatform SQL command line tools such as sqlcmd.

Oracle, ODBC, DB2-CLI Template Library


Oracle, ODBC, DB2-CLI Template Library (OTL). Provides C++ stream like interface to relational databases (SQL), like Oracle, MS SQL Server, DB2, MySQL, PostgreSQL, Interbase, etc. Multi-database, multi-platform, portable, high performance.



mygrate - SQL file based database migrations for MySQL and PostgreSQL


Database migrations for MySQL, PostgreSQL and SQL Server database using plain SQL files. The end goal is to have migration scripts that can be run by a DBA.That command creates migration/TIMESTAMP-add-tables/{down,up}.sql. Edit up.sql which is run by mygrate up command. Edit down.sql which is run by mygrate down command.

LibreOffice - The Document foundation


LibreOffice is the free power-packed Open Source personal productivity suite for Windows, Macintosh and Linux. LibreOffice is the perfect choice for home users, businesses, government and other organizations. It's native file format is the ISO standardized ODF (Open Document Format), but LibreOffice can open and save Microsoft Word, PowerPoint and Excel files, as well as many other formats, bringing you the widest-available compatibility with other products.

DBeaver - Universal SQL Manager and SQL Client


DBeaver is a multi-platform database tool for developers, SQL programmers, database administrators and analysts. It supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc. Its feature include metadata editor, SQL editor, rich data editor, ERD, data export/import/migration, SQL execution plans, etc.

PostGIS - Spatial and Geographic objects for PostgreSQL


PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL. PostGIS adds extra types (geometry, geography, raster and others) to the PostgreSQL database. It also adds functions, operators, and index enhancements that apply to these spatial types.

Chinook Database


Chinook is a sample database available for SQL Server, Oracle, MySQL, etc. It can be created by running a single SQL script. Chinook database is an alternative to the Northwind database, being ideal for demos and testing ORM tools targeting single and multiple database servers.

db-model - Database model and reverse engineering for Oracle, PostgreSQL, MS SQL, MySQL.


Database model and reverse engineering for Oracle, PostgreSQL, MS SQL, MySQL.

Database-Application-Development


SASA is team of database experts, we are expert in database managment expert, database application migration and mining our expert provide solution in Oracle Mysql Microsoft SQL Server DB2 PostgreSQL. We are based in India

Database-Application-Development


SASA is team of database experts, we are expert in database managment expert, database application migration and mining our expert provide solution in Oracle Mysql Microsoft SQL Server DB2 PostgreSQL. We are based in India

Database-Application-Development


SASA is team of database experts, we are expert in database managment expert, database application migration and mining our expert provide solution in Oracle Mysql Microsoft SQL Server DB2 PostgreSQL. We are based in India

Database-Application-Development


SASA is team of database experts, we are expert in database managment expert, database application migration and mining our expert provide solution in Oracle Mysql Microsoft SQL Server DB2 PostgreSQL. We are based in India

FluentData -Micro ORM with a fluent API that makes it simple to query a database


A simple to use Micro ORM with a great fluent API that makes it simple to select, insert, update and delete data in a database. Supported databases: Microsoft SQL Server, MS SQL Server Compact, MS SQL Azure, Oracle and MySQL.

SQL Compact Command Line Tool


Administer SQL Compact databases directly from the command line, without having Visual Studio or SQL Server Management Studio installed. Only requires NetFx 2.0 and SQL Compact installed. Command line options similar to sqlcmd. Also runs any SQL Compact script files.

iSQL-Viewer - JDBC compliant database front end


iSQL-Viewer is JDBC compliant database front end. It implements across multiple platforms features of the JDBC API. It does everything through a single interface. iSQL-Viewer works with most database platforms, including PostgreSQL, MySQL, Oracle, and Informix.

DB Util


Portable shell (command line) program written in Java to access database servers that support JDBC. For the beginning mySQL, PostgreSQL, Microsoft SQL Server are supported.

Hibernate - Relational Persistence for Java


Hibernate facilitated the storage and retrieval of domain objects via Object/Relational Mapping. Today, Hibernate is a collection of related projects enabling developers to utilize POJO-style domain models in their applications in ways extending well beyond Object/Relational Mapping.