Search Results for "run sql command line"
Sort By:
Showing 214 open source projects for "run sql command line"
View related business solutions-
Gemini 3 and 200+ AI Models on One PlatformBuild generative AI apps with Vertex AI. Switch between models without switching platforms.
-
Try Google Cloud Risk-Free With $300 in CreditUse your credit across every product. Compute, storage, AI, analytics. When it runs out, 20+ products stay free. You only pay when you choose to.
-
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
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. -
3
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. ... -
4
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. ... -
MongoDB Atlas runs apps anywhereMongoDB Atlas gives you the freedom to build and run modern applications anywhere—across AWS, Azure, and Google Cloud. With global availability in over 115 regions, Atlas lets you deploy close to your users, meet compliance needs, and scale with confidence across any geography.
-
5
DbTpl
Command line tool to generate idiomatic Go code for SQL databases
dbtpl is a Go-based tool that brings templated SQL into your codebase in a clean and structured way. It allows developers to define raw SQL queries in .tpl.sql files and compile them into Go code with strong typing and minimal overhead. By combining SQL’s power with Go’s safety and performance, dbtpl is ideal for teams that want full SQL control without sacrificing maintainability. -
6
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. -
7
Database connection pool with support for lots of languages and databases.
-
8
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... -
9
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. -
AI-generated apps that pass security reviewRetool lets you generate dashboards, admin panels, and workflows directly on your data. Type something like “Build me a revenue dashboard on my Stripe data” and get a working app with security, permissions, and compliance built in from day one. Whether on our cloud or self-hosted, create the internal software your team needs without compromising enterprise standards or control.
-
10
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. -
11
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. -
12
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. -
13
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... -
14
FluentMigrator
Fluent migrations framework for .NET
Fluent Migrator is a migration framework for .NET much like Ruby on Rails Migrations. Migrations are a structured way to alter your database schema and are an alternative to creating lots of sql scripts that have to be run manually by every developer involved. Migrations solve the problem of evolving a database schema for multiple databases (for example, the developer's local database, the test database and the production database). Database schema changes are described in classes written in... -
15
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. ... -
16
LocustDB
Massively parallel, high performance analytics database
...See How to Analyze Billions of Records per Second on a Single Desktop PC and How to Read 100s of Millions of Records per Second from a Single Disk for an overview of current capabilities. Download the latest binary release, which can be run from the command line on most x64 Linux systems, including Windows Subsystem for Linux. When loading .csv or .csv.gz files with --load, the first line of each file is assumed to be a header containing the names for all columns. The type of each column will be derived automatically, but this might break for columns that contain a mixture of numbers/strings/empty entries. ... -
17
mariadb-gensql
A program to generate SQL statements bason on a template
This tool is useful to generate random data and / or workload for testing purposes. One or more SQL statement templates are passed, then placeholders in the SQL statement is replaced as appropriate before the statement is run. This allows random data to be generated, as well as an appropriate workload. The load is also multi-threaded and connections to multiple MariaDB servers is also supported. -
18
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. -
19
-
20
mymssqldump
A tool to dump data from SQL Server in text format
SQL Server is sometimes difficult to get data from i some generic format, such as CSV. This program does just that. It allows SQL Server and Sybase (but this is not tested) tables to be exported in a variety of formats, including JSON, CSV and MySQL / MariaDB. -
21
Virtuoso is a scalable cross-platform server that combines Relational, Graph, and Document Data Management with Web Application Server and Web Services Platform functionality.
-
22
Object-Relational Main-Memory Embedded Database system tightly integrated with C++ language. Use OS virtual mapping mechanism to access data. Provides subset of SQL language with OO extensions. Support of transactions, fault tolerance, replication.
-
23
Jailer
Database Subsetter and Relational Data Browser
Database Subsetting and Relational Data Browsing Tool. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships. Exports consistent, referentially intact row-sets from relational databases. Removes data w/o violating integrity. Generates topologically sorted SQL-DML, hierarchically structured XML. and DbUnit datasets. -
24
SRDB
Small Client/Server SQL Relational Database System
Small client/server SQL system with terminal based client. Requires Linux running systemd. See README for more info. Written in C++. -
25
ldap-preg_replace
Replace/add/delete LDAP attributes online with regular expressions
Replace, add and delete values of LDAP attributes online with regular expressions. Automate daunting data maintenance Tasks. Save yourself from the need to fiddle around with LDIF Change files (or create them based on the replacement result)!
