Search Results for "sql command line"
Sort By:
Showing 591 open source projects for "sql command line"
View related business solutions-
Demo Series - Small Business Backup By VeeamWatch this on-demand demo series and learn how to protect your Microsoft 365 data with clear, simple, actionable steps that are easy to implement for businesses of all sizes.
-
Cut Data Warehouse Costs by 54%BigQuery delivers 54% lower TCO with exabyte scale and flexible pricing. Free migration tools handle the SQL translation automatically.
-
1
SQL Studio
SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB
SQL Studio is a database explorer supporting multiple databases like SQLite, libSQL, PostgreSQL, MySQL/MariaDB, DuckDB, and ClickHouse. -
2
usql
Universal command-line interface for SQL databases
usql is a universal command-line interface for PostgreSQL, MySQL, Oracle Database, SQLite3, Microsoft SQL Server, and many other databases including NoSQL and non-relational databases! usql provides a simple way to work with SQL and NoSQL databases via a command-line inspired by PostgreSQL's psql. usql supports most of the core psql features, such as variables, backticks, and commands and has additional features that psql does not, such as syntax highlighting, context-based completion, and multiple database support. ... -
3
Squawk
Linter for Postgres migrations & SQL
Squawk is a static SQL linter for PostgreSQL designed to catch common mistakes and enforce query best practices. It analyzes raw SQL files and flags errors, anti-patterns, or style issues before queries are deployed. Squawk is ideal for teams that want to enforce SQL standards in CI pipelines. -
4
Dbmate
A lightweight, framework-agnostic database migration tool
...Uses plain SQL for writing schema migrations. Migrations are timestamp-versioned, to avoid version number conflicts with multiple developers. Migrations are run atomically inside a transaction. Supports creating and dropping databases (handy in development/test). Supports saving a schema.sql file to easily diff schema changes in git. Database connection URL is defined using an environment variable (DATABASE_URL by default), or specified on the command line. -
Paessler: Easy to Use With Enterprise Power. Free TrialYou shouldn't have to choose between a monitoring tool that's easy to use and one that's powerful enough for a complex environment. PRTG's low-code interface lets any admin build dashboards, set alerts and monitor devices without scripting, while custom sensors and full API access are there when your team needs deeper control. One platform, no compromise. Download a free 30-day trial now.
-
5
dblab
The database client every command line junkie deserves
dblab is a fast and lightweight interactive terminal based UI application for PostgreSQL, MySQL and SQLite3, written in Go and works on OSX, Linux and Windows machines. Main idea behind using Go for backend development is to utilize ability of the compiler to produce zero-dependency binaries for multiple platforms. dblab was created as an attempt to build very simple and portable application to work with local or remote PostgreSQL/MySQL/SQLite3/Oracle/SQL Server databases. -
6
sqlite-web
Web-based SQLite database browser written in Python
...It lets users open existing SQLite databases or create new ones through a browser interface. The tool can browse table data, inspect database structure, and run arbitrary SQL queries from a dedicated query tab. It also supports common editing actions, including inserting, updating, and deleting rows. Users can add or drop tables, columns, and indexes, and they can import or export data in JSON or CSV format. It can run from the command line, through Docker, or with a higher-performance gevent WSGI server, making it useful for quick database inspection, lightweight administration, and local development workflows. -
7
Database connection pool with support for lots of languages and databases.
-
8
dbatools
SQL Server automation and instance migrations have never been safer
Instance migrations and best practice implementations have never been safer, faster or freer. dbatools is PowerShell module that you may think of like a command-line SQL Server Management Studio. The project initially started out as just Start-SqlMigration.ps1, but has now grown into a collection of over 500 commands that help automate SQL Server tasks and encourage best practices. dbatools now works on PowerShell Core (aka PowerShell 6+). This means that you can run a large majority of our commands on Linux and macOS. ... -
9
mycli
CLI for MySQL with auto-completion and syntax highlighting
mycli is an enhanced command-line client for MySQL and MariaDB that features syntax highlighting and intelligent auto-completion for database queries. Built for developers and DBAs, it improves productivity with features like query history, table suggestions, and colored output. The tool is designed to be both powerful and user-friendly, making interactive database work more efficient and visually intuitive. -
Go from Code to Production URL in SecondsSkip the Kubernetes configs. Cloud Run handles HTTPS, scaling, and infrastructure automatically. Two million requests free per month.
-
10
Ora2Pg
Ora2Pg is a free tool used to migrate an Oracle database
ora2pg is an open-source tool used to migrate Oracle databases to PostgreSQL. It connects to an Oracle database, extracts schema and data, and generates SQL-compatible output for PostgreSQL. It supports complex migration scenarios, including stored procedures, triggers, data types, and performance optimization, making it ideal for enterprises transitioning away from Oracle systems. -
11
Grafana
Leading open-source visualization and observability platform
Grafana OSS is the leading open-source platform for visualization and observability. It enables teams to query, visualize, alert on, and explore telemetry data from multiple sources in a single interface. With support for 100+ data source plugins—including Prometheus, Loki, Elasticsearch, InfluxDB, SQL/NoSQL databases, and OpenTelemetry—Grafana helps teams correlate metrics, logs, and traces across applications and infrastructure. Users can build interactive dashboards with rich... -
12
Squel
SQL query string builder for Javascript
Squel is a JavaScript library for fluent and safe SQL query string building, usable both in Node.js environments and in the browser. Works in Node.js and in the browser. Supports the standard SQL queries: SELECT, UPDATE, INSERT, and DELETE. Supports non-standard commands for popular DB engines such as MySQL. Supports parameterized queries for safe value escaping. It can be customized to build any query or command of your choosing. -
13
Adminer
Database management in a single PHP file
Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, MongoDB and others via plugin. Replace phpMyAdmin with Adminer and you will get a tidier user interface, better support for MySQL features, higher performance and more security. Connect to a database server with username... -
14
Phinx
PHP database migrations for everyone
Most database migration tools are framework-dependent, complicated, confusing to install/configure and a pain in the ass to write migrations for. In less than 5 minutes you can install Phinx, create and execute your first migration. Phinx supports migrations written in both PHP and SQL. Use the PHP syntax to make your migrations portable between different database vendors or hand-code advanced queries. It's your choice. As Phinx executes from the command-line, it is painless to integrate with your deploy, build or CI tool. Phinx is and will always remain completely free, open-source software. Developers are encouraged to fork, hack and modify Phinx. ... -
15
pgCenter
Command-line admin tool for observing and troubleshooting Postgres
pgCenter is a command-line monitoring and troubleshooting tool for PostgreSQL, inspired by tools like top. It provides real-time insight into query activity, locks, I/O, and system resources directly from the terminal. With its interactive UI, pgCenter helps DBAs diagnose performance issues and manage server health without switching tools. -
16
Duplicati
Store securely encrypted backups in the cloud!
Duplicati is a free and open source backup client for securely storing your data. Duplicati stores encrypted, incremental, compressed backups on cloud storage services and remote file servers using AES-256 encryption, keeping your data safe and always updated. It works with most storage services, including Google Cloud and Drive, Amazon S3, Microsoft Azure and OneDrive, Dropbox, FTPOpenStack Storage (Swift), SSH (SFTP), WebDAV, Tencent Cloud Object Storage (COS), and more! Duplicati also... -
17
pgstream
PostgreSQL replication with DDL changes
pgstream is an open source CDC command-line tool and library that offers Postgres replication support with DDL changes to any provided output. One of the main differentiators of pgstream is the fact that it tracks and replicates schema changes automatically. It relies on SQL triggers that will populate a Postgres table (pgstream.schema_log) containing a history log of all DDL changes for a given schema. -
18
Dolt
Dolt, it's Git for data
Dolt is a SQL database that you can fork, clone, branch, merge, push and pull just like a git repository. Connect to Dolt just like any MySQL database to run queries or update the data using SQL commands. Use the command line interface to import CSV files, commit your changes, push them to a remote, or merge your teammate's changes. All the commands you know for Git work exactly the same for Dolt. -
19
CloudBeaver
Cloud Database Manager
Cloud Database Manager, community edition.CloudBeaver is a web server that provides rich web interface. The server itself is a Java application, the web part is written on TypeScript and React. It is free to use and open-source (licensed under Apache 2 license). CloudBeaver is a light modern web application for database management. Out-of-the-box CloudBeaver supports various SQL, NoSQL and BigData data sources. It is really easy to set up CloudBeaver. In a few clicks you can configure your... -
20
CodeChecker
CodeChecker is an analyzer tooling, defect database
...Incremental analysis: Only the changed files and its dependencies need to be reanalyzed. False positive suppression with a possibility to add review comments. Result visualization in command line or in static HTML. Web application for viewing discovered code defects with a streamlined, easy experience (with PostgreSQL, or SQLite backend). -
21
VictoriaMetrics
VictoriaMetrics: fast, cost-effective monitoring solution
...It features easy setup and operation. VictoriaMetrics consists of a single small executable without external dependencies. All the configuration is done via explicit command-line flags with reasonable defaults. All the data is stored in a single directory pointed by -storageDataPath command-line flag. -
22
pgroll
PostgreSQL zero-downtime migrations made easy
pgroll is an open-source command-line tool for performing zero-downtime, reversible schema migrations on PostgreSQL databases. It allows developers to define migrations using a high-level JSON format and manages the migration process to ensure application availability during schema changes. -
23
node-pg-migrate
Node.js database migration management for Postgresql
Node.js database migration management built exclusively for postgres. (But can also be used for other DBs conforming to SQL standard - e.g. CockroachDB.) Started by Theo Ephraim, now maintained by Salsita Software. Installing this module adds a runnable file into your node_modules/.bin directory. If installed globally (with the -g option), you can run node-pg-migrate and if not, you can run ./node_modules/.bin/node-pg-migrate. Add "migrate": "node-pg-migrate" to scripts section of... -
24
SchemaCrawler
Free database schema discovery and comprehension tool
SchemaCrawler is a free database schema discovery and comprehension tool. SchemaCrawler has a good mix of useful features for data governance. You can search for database schema objects using regular expressions, and output the schema and data in a readable text format. The output serves for database documentation, and is designed to be diff-ed against other database schemas. SchemaCrawler also generates schema diagrams. You can execute scripts in any standard scripting language against your... -
25
go-sqlite3
sqlite3 driver for go using database/sql
sqlite3 driver conforming to the built-in database/sql interface. This package can be installed with the go-get command. go-sqlite3 is cgo package. If you want to build your app using go-sqlite3, you need gcc. However, after you have built and installed go-sqlite3 with go install github.com/mattn/go-sqlite3 (which requires gcc), you can build your app without relying on gcc in the future.
