Automic VaultAutomic Vault

brew

Install sql-translator with Homebrew, dnf

Manipulate structured data definitions (SQL and more). Version 1.66 via Homebrew; verified 2026-05-26.

install

Additional install commands

macOS

Homebrewverified · 100%
brew install sql-translator

local Homebrew formula metadata

overview

Package summary

Manipulate structured data definitions (SQL and more)

Commands and aliases

  • sqlt
  • sqlt-diagram
  • sqlt-diff
  • sqlt-diff-old
  • sqlt-dumper
  • sqlt-graph

history

Project history and usage

SQL::Translator, also known historically as SQLFairy, is a Perl distribution for translating structured data definitions. MetaCPAN describes it as converting vendor-specific SQL table definitions into other formats including other SQL dialects, diagrams, documentation, XML, and Class::DBI classes.

Project history

The current GitHub repository was created in February 2011, while the module documentation and metadata preserve older CPAN-era identity and support channels. The distribution remains maintained on CPAN, with version 1.66 released in November 2024.

Adoption history

SQL::Translator belongs to the CPAN tool culture where command-line scripts and Perl modules are distributed together. The Homebrew formula exposes several executables, including `sqlt`, `sqlt-diagram`, `sqlt-diff`, `sqlt-dumper`, and `sqlt-graph`, making the CPAN distribution available to users who prefer system package managers.

How it is used

Users commonly call the `sqlt` family of commands to translate, diff, diagram, or dump database schemas, or use the Perl API by constructing a translator with parser and producer options such as MySQL input and Oracle output. The module focuses on SQL definition language such as CREATE and ALTER rather than data manipulation.

Why package nerds care

Package nerds care about SQL::Translator because it is an old, cross-dialect schema plumbing tool with many optional outputs and executables. It is the kind of utility that appears in migration scripts, documentation generation, ORM-era workflows, and distro package sets because it bridges database dialects rather than belonging to one database vendor.

Timeline

  • 2011: Current GitHub repository created.
  • 2015: Changelog documents fixes for SQLite, MySQL, PostgreSQL, SQL Server, and Oracle quoting and parsing.
  • 2019: 1.60 released after the 1.59 development series.
  • 2024: 1.66 released on CPAN.

Related projects

  • The official documentation names Parse::RecDescent, GD, GraphViz, Text::RecordParser, Class::DBI, and XML::Writer as related technologies. The module also includes parser and producer namespaces for multiple database dialects and output formats.

security posture

Risk level: blue

broad file, network, media, or database tool signal.

Risk classifier

blue risk · medium confidence · tool

Why

  • broad file, network, media, or database tool signal

Signals

  • text:sql

Install behavior

  • No Homebrew post-install hook is recorded in formula metadata.
  • Homebrew bottle metadata is available for 8 platform targets.

Recommended review

Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.

executables

Installed executables

CommandKindExposureNote
sqltcliglobal executable
sqlt-diagramcliglobal executable
sqlt-diffcliglobal executable
sqlt-diff-oldcliglobal executable
sqlt-dumpercliglobal executable
sqlt-graphcliglobal executable

freshness

Version and freshness

These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.

page generated2026-07-08
manager version1.66
manager updated2026-05-26
local dataok
upstreamnot checked
latest detectednot detected

https://github.com/dbsrgits/sql-translator

install metadata

Package metadata

Package keybrew:sql-translator
Version1.66
Package managerHomebrew
Package manager pagehttps://formulae.brew.sh/formula/sql-translator
Homepagehttps://github.com/dbsrgits/sql-translator/
Repositoryhttps://github.com/dbsrgits/sql-translator
Upstream docshttps://metacpan.org/pod/SQL::Translator
LicenseArtistic-1.0-Perl OR GPL-1.0-or-later
Source archivehttps://cpan.metacpan.org/authors/id/V/VE/VEESH/SQL-Translator-1.66.tar.gz
Last updated2026-05-26T02:26:19Z
Pulseupdated
Uses from macOSperl
Bottleavailable (on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sequoia, sonoma, tahoe, x86_64_linux)
Homebrew post-installnot defined
Servicenone declared

registry facts

Source database details

Source DatabaseHomebrew formula API
Taphomebrew/core
Full Namesql-translator
Version Scheme0
Revision0
Bottle Stable Root URLhttps://ghcr.io/v2/homebrew/core
Deprecatedno
Disabledno
Keg Onlyno
URL Keys
  • stable

source database matches

Other package-manager records

Matches are pulled from external package-manager indexes and kept separate from local Automic Vault package links.

dnf92%

sqlt-graph 1.66-4.fc44

sqlt-graph tool to create a graph from a database schema

https://metacpan.org/release/SQL-Translator

sudo dnf install sqlt-graph
  • License: GPL-2.0-only
  • Category: Unspecified
  • Architecture: noarch
  • Source Package: perl-SQL-Translator
  • 2 dependencies
  • 1 provides
  • installed executable or alias match
  • Matched by: Sqlt Graph
Fedora Rawhide package metadata · dl.fedoraproject.org · Fedora Rawhide package metadata: sqlt-graph from https://dl.fedoraproject.org/pub/fedora/linux/development/rawhide/Everything/x86_64/os/repodata/e5ca8ce900cd68f5419e1c39ae517343100b306336cbaeb70a3c153121d95094-primary.xml.zst

source trail

Generated from repository data

This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.

Used sources

  • Geiger risk classifier
  • Nucleus package database
  • av.db category and tag curation
  • cross-ecosystem install command graph
  • curated package history
  • external package-manager database matches
  • package relationship graph
  • package version freshness
  • package-page enrichment