Search Results for "mysql database scripts"

Dbmate is a database migration tool, to keep your database schema in sync across multiple developers and your production servers. It is a standalone command line tool, which can be used with Go, Node.js, Python, Ruby, PHP, or any other language or framework you are using to write database-backed applications. This is especially helpful if you are writing many services in different languages, and want to maintain some sanity with consistent development tools.

...Each tool favors guardrails: dry runs, throttling, and resumable operations reduce the risk of harming production workloads. Operators and DBAs rely on the toolkit to bring observability and predictability to busy database fleets without hand-rolled scripts.

sq is a command line tool that provides jq-style access to structured data sources: SQL databases, or document formats like CSV or Excel. sq executes jq-like queries, or database-native SQL. It can join across sources: join a CSV file to a Postgres table, or MySQL with Excel. sq outputs to a multitude of formats including JSON, Excel, CSV, HTML, Markdown and XML, and can insert query results directly to a SQL database. sq can also inspect sources to view metadata about the source structure (tables, columns, size). ...

csv2odf can create business intelligence reports from csv data sources with output to ods, odt, html, xlsx, or docx documents. It uses a template file that you design to control the layout, fonts, and colors. Just query your database with output to csv (or tsv), then use csv2odf to insert the data into your template to produce a nice looking formatted output. It is a command line tool and you can automate the generation of reports by using scripts and cron. It can be used to create spreadsheets and documents for LibreOffice, OpenOffice, Microsoft Office Excel and Word. ...

The Data Migration Tool Automator is tool for simplifying the use of the Filemaker Data Migration Tool (FDMT) . The FDMT is a command line tool published by Filemaker that facilitates the migration of data from an existing production database to a new clone version of the same database. The problem with the FDMT is that it is a command line tool which requires long and complicated instructions to execute. It can take several attempts and a lot of time to get the exact instruction you need. The Filemaker Data Migration Tool Automator is a Filemaker database which makes it easy to create the command line syntax and calls the terminal scripts for the Filemaker Data Migration Tool. ...

jdbc2csv is a small command-line tool written in JAVA and can be used on all platforms, for which JRE 8 or higher is available. To connect to a specific DBMS the tool uses its JDBC driver. The result of the executed 'select' query is displayed in CSV format ( different standards are supported ). When there is an error the tool stops with exit code 1 and the error message is output on stderr. jdbc2csv is created with a main purpose to be used in shell-scripts. Relatively easy to configurate,...

caniuse-cmd is a command-line interface tool that brings the power of caniuse.com—the web compatibility database—directly into your terminal, enabling quick checks of browser support without the UI. You can specify your own defaults by creating a file called .caniuse.json and putting it in your home directory. Install with npm install -g caniuse-cmd. All the power of caniuse with none of the nice UI or interactivity.

Command-line tool for database saving/displaying of instant messaging history written in Perl.

Command line tool for syncronize heterogeneous databases. Work via QT4 drivers (Drivers for SQLite, QDBC, Firebird are included. Drivers for IBase, DB2, Postgeress, Mysql may be compilled by Qt4 (4.7.0 for 0.0.4)))

omnimysql is a command line tool for DBAs needing to issue ad-hoc queries against sharded data.

ScriptManager is a command-line tool for executing and managing plain SQL scripts. ScriptManager was written in pure Java and requires JDBC driver to connect to any JDBC-compliant database.

This is a command-line tool, written in perl, that will convert from any database supported by perl DBI that also supports the information_schema standard to a MySQL database. It was written to convert from SQL Server to MySQL.