Search Results for "sql command line"
Sort By:
Showing 519 open source projects for "sql command line"
View related business solutions-
Network Management Software and Tools for Businesses and Organizations | Auvik NetworksReduce IT headaches and save time with a proven solution for automated network discovery, documentation, and performance monitoring. Choose Auvik because you'll see value in minutes, and stay with us to improve your IT for years to come.
-
SoftCo: Enterprise Invoice and P2P Automation SoftwareSoftCo Accounts Payable Automation processes all PO and non-PO supplier invoices electronically from capture and matching through to invoice approval and query management. SoftCoAP delivers unparalleled touchless automation by embedding AI across matching, coding, routing, and exception handling to minimize the number of supplier invoices requiring manual intervention. The result is 89% processing savings, supported by a context-aware AI Assistant that helps users understand exceptions, answer questions, and take the right action faster.
-
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. -
Comet Backup - Fast, Secure Backup Software for MSPsComet is a flexible backup platform, giving you total control over your backup environment and storage destinations.
-
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
Database connection pool with support for lots of languages and databases.
-
7
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. -
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
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... -
The full-stack observability platform that protects your dataLayer, tags and conversion dataCode-Cube.io detects issues instantly, alerts you in real time and helps you resolve them fast. No manual QA. No unreliable data. Just data you can trust and act on.
-
10
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. -
11
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. -
12
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. ... -
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
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... -
15
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. -
16
QuestDB
An open source SQL database designed to process time series data
QuestDB is a high-performance, open-source SQL database for applications in financial services, IoT, machine learning, DevOps and observability. It includes endpoints for PostgreSQL wire protocol, high-throughput schema-agnostic ingestion using InfluxDB Line Protocol, and a REST API for queries, bulk imports, and exports. QuestDB implements ANSI SQL with native extensions for time-oriented language features. -
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
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. -
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
Dynein
DynamoDB CLI written in Rust
Dynein is an open-source command-line interface (CLI) for AWS DynamoDB that provides advanced querying, data management, and administrative operations for NoSQL workloads. -
21
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). -
22
WAL-G
Archival and Restoration for databases in the Cloud
WAL-G is an archival restoration tool for PostgreSQL, MySQL/MariaDB, and MS SQL Server (beta for MongoDB and Redis). WAL-G is the successor of WAL-E with a number of key differences. WAL-G uses LZ4, LZMA, ZSTD, or Brotli compression, multiple processors, and non-exclusive base backups for Postgres. More information on the original design and implementation of WAL-G can be found on the Citus Data blog post "Introducing WAL-G by Citus: Faster Disaster Recovery for Postgres". A precompiled... -
23
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... -
24
AriaNg
A modern web frontend making aria2 easier to use
AriaNg is a modern web frontend making aria2 easier to use. AriaNg is written in pure html & javascript, thus it does not need any compilers or runtime environment. You can just put AriaNg in your web server and open it in your browser. AriaNg uses responsive layout, and supports any desktop or mobile devices. Sort tasks (by name, size, progress, remaining time, download speed, etc.), files, bittorrent peers. Search tasks, and retry tasks. Adjust task order by dragging. More information of... -
25
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...
