--- title: Install SQL Query Formatter on Ubuntu using the Snap Store | Snapcraft description: Get the latest version of SQL Query Formatter for on Ubuntu - SQL query formatter, DDL schema ER diagram studio, and vector/PDF exporter url: https://snapcraft.io/install/sql-query-formatter/ubuntu --- [Canonical Snapcraft](https://snapcraft.io/) # Install SQL Query Formatter on **Ubuntu** # SQL Query Formatter [TC Studio (thanhcong1902)](https://snapcraft.io/publisher/thanhcong1902 "View all snaps from TC Studio (thanhcong1902)") * [TC Studio (thanhcong1902)](https://snapcraft.io/publisher/thanhcong1902 "View all snaps from TC Studio (thanhcong1902)") [Install](https://snapcraft.io/install/sql-query-formatter/ubuntu#install) #### SQL query formatter, DDL schema ER diagram studio, and vector/PDF exporter SQL Query Formatter is a desktop SQL tokenizer, pretty-printer, DDL Entity-Relationship diagram studio, and vector/document exporter for Linux developers and database engineers. Format complex multi-CTE SELECT queries, joins, CASE expressions, DML statements, and CREATE TABLE DDL locally on your desktop without uploading schemas to external services. Key Features: * SQL Tokenizer & Pretty-Printer: Pure-Python SQL lexer and formatter supporting SELECT, WITH CTEs, JOINs, CASE expressions, INSERT, UPDATE, and CREATE TABLE with UPPER/lower/Title keyword casing, configurable indent width, trailing or comma-first style, dialect awareness, syntax highlighting, and compact Minifier. * Visual ER Diagram Studio: Parses CREATE TABLE DDL (PRIMARY KEY, FOREIGN KEY REFERENCES) into an interactive, draggable, auto-laid-out Entity-Relationship diagram rendered with QPainter featuring table cards, PK/FK badges, and crow's-foot relationship connectors. * Schema & Diagram Exporter: Exports formatted .sql scripts, standalone vector SVG diagrams, high-DPI PNG renders, and print-ready vector PDF documents via QPdfWriter. Disclaimer: SQL Query Formatter is an independent open-source project by TC Studio and is not affiliated with, endorsed by, or sponsored by any third-party database formatting vendor. ### Package name * sql-query-formatter --- ### License * MIT --- ### Last updated * Yesterday - latest/stable --- ##### Report a Snap Store violation * [Report this Snap](https://snapcraft.io/install/sql-query-formatter/ubuntu#report-snap-modal) --- [See more information about sql-query-formatter ›](https://snapcraft.io/sql-query-formatter) ## Enable snaps on Ubuntu and install SQL Query Formatter Snaps are applications packaged with all their dependencies to run on all popular Linux distributions from a single build. They update automatically and roll back gracefully. Snaps are discoverable and installable from the [Snap Store](https://snapcraft.io/store), an app store with an audience of millions. ### Enable snapd If you’re running [Ubuntu 16.04 LTS (Xenial Xerus)](https://www.ubuntu.com/) or later, including [Ubuntu 18.04 LTS (Bionic Beaver)](https://www.ubuntu.com/desktop/features) and [Ubuntu 20.04 LTS (Focal Fossa)](https://wiki.ubuntu.com/FocalFossa/ReleaseNotes), you don’t need to do anything. Snap is already installed and ready to go. For versions of Ubuntu between [14.04 LTS (Trusty Tahr)](https://wiki.ubuntu.com/TrustyTahr/ReleaseNotes) and [15.10 (Wily Werewolf)](https://wiki.ubuntu.com/WilyWerewolf/ReleaseNotes), as well as Ubuntu flavours that don’t include *snap* by default, *snap* can be installed from the Ubuntu Software Centre by searching for *snapd*. Alternatively, snapd can be installed from the command line: ``` sudo apt update sudo apt install snapd ``` Either log out and back in again, or restart your system, to ensure snap’s paths are updated correctly. ### Install SQL Query Formatter To install SQL Query Formatter, simply use the following command: ``` sudo snap install sql-query-formatter ``` ### Other popular snaps… [See more...](https://snapcraft.io/search?categories=featured) [See more in Featured](https://snapcraft.io/search?categories=featured) ### More things to do… #### [Get the snap store](https://snapcraft.io/snap-store) Browse and find snaps from the convenience of your desktop using the snap store snap. #### [Learn more about snaps](https://snapcraft.io/docs) Interested to find out more about snaps? Want to publish your own application? Visit [snapcraft.io](https://snapcraft.io/) now. [Back to top](https://snapcraft.io/install/sql-query-formatter/ubuntu) © 2026 Canonical Ltd. Ubuntu and Canonical are registered trademarks of Canonical Ltd. Powered by [Charmed Kubernetes](https://www.ubuntu.com/kubernetes) [Join the forum](https://forum.snapcraft.io/), contribute to or report problems with, [snapd](https://bugs.launchpad.net/snapd), [Snapcraft](https://bugs.launchpad.net/snapcraft), or [this site](https://github.com/canonical/snapcraft.io/issues/new). * [Share on Twitter](https://twitter.com/snapcraftio) * [Share on Facebook](https://www.facebook.com/snapcraftio) * [Share on YouTube](https://www.youtube.com/snapcraftio) * [Terms of Service](https://ubuntu.com/legal/terms-and-policies/snap-store-terms) * [Data privacy](https://www.ubuntu.com/legal/data-privacy) * [Manage your tracker settings](https://snapcraft.io/install/sql-query-formatter/ubuntu) * [Service status](https://status.snapcraft.io/) * [Other functions](https://dashboard.snapcraft.io/) * [Contact us](https://snapcraft.io/about/contact-us)