notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine

Bot filter coming soon

To deter bots pegging the database CPU to 100%, a bot testing filter to be added to the website. This should not affect newsfeeds etc. Anubis seems light-weight - it is already in use within the FreeBSD Project. This notice is just a heads up in case you see something odd. This notice will be updated after Anubis is installed.

Port details
py-shandy-sqlfmt Sqlfmt formats your dbt SQL files so you don't have to
0.26.0 develnew! on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout Package not present on quarterly.This port was created during this quarter. It will be in the next quarterly branch but not the current one.
Maintainer: ume@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2025-05-31 14:48:05
Last Update: 2025-05-31 14:47:41
Commit Hash: 5d1b719
Also Listed In: python
License: APACHE20
WWW:
https://sqlfmt.com
https://github.com/tconbeer/sqlfmt
Description:
sqlfmt formats your dbt SQL files so you don't have to. It is similar in nature to black, gofmt, and rustfmt (but for SQL). sqlfmt promotes collaboration. An auto-formatter makes it easier to collaborate with your team and solicit contributions from new people. You will never have to mention (or argue about) code style in code reviews again. sqlfmt is fast. Forget about formatting your code, and spend your time on business logic instead. sqlfmt processes hundreds of files per second and only operates on files that have changed since the last run. sqlfmt works with Jinja. It formats the code that users look at, and therefore doesn't need to know anything about what happens after the templates are rendered. sqlfmt integrates with your workflow. As a CLI written in Python, it's easy to install locally on any OS and run in CI. Plays well with dbt, pre-commit, SQLFluff, VSCode, and GitHub Actions. sqlfmt powers the dbt Cloud IDE's Format button. sqlfmt is not configurable, except for line length. It enforces a single style. sqlfmt maintains comments and some extra newlines, but largely ignores all indentation and line breaks in the input file. sqlfmt is not a linter. It does not parse your code into an AST; it just lexes it and tracks a small subset of tokens that impact formatting. This lets us "do one thing and do it well:" sqlfmt is very fast, and easier to maintain and extend than linters that need a full SQL grammar. For now, sqlfmt only works on select, delete, grant, revoke, and create function statements (which is all you need if you use sqlfmt with a dbt project). It is being extended to additional DDL and DML. Visit this tracking issue for more information.
HomepageHomepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
There is no configure plist information for this port.
Dependency lines:
  • ${PYTHON_PKGNAMEPREFIX}shandy-sqlfmt>0:devel/py-shandy-sqlfmt@${PY_FLAVOR}
To install the port:
cd /usr/ports/devel/py-shandy-sqlfmt/ && make install clean
To add the package, run one of these commands:
  • pkg install devel/py-shandy-sqlfmt
  • pkg install py311-shandy-sqlfmt
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
NOTE: This is a Python port. Instead of py311-shandy-sqlfmt listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py311-shandy-sqlfmt
Package flavors (<flavor>: <package>)
  • py311: py311-shandy-sqlfmt
distinfo:
TIMESTAMP = 1748694868 SHA256 (shandy_sqlfmt-0.26.0.tar.gz) = d95abd381640a846c71b0e2effb30d47f0b3eb5f69fb337fafe663634857f7a5 SIZE (shandy_sqlfmt-0.26.0.tar.gz) = 62228

No package information for this port in our database
Sometimes this happens. Not all ports have packages. This is doubly so for new ports, like this one.
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py311-poetry-core>=1.0.0 : devel/py-poetry-core@py311
  2. python3.11 : lang/python311
  3. py311-build>=0 : devel/py-build@py311
  4. py311-installer>=0 : devel/py-installer@py311
Test dependencies:
  1. python3.11 : lang/python311
Runtime dependencies:
  1. py311-black>=0 : devel/py-black@py311
  2. py311-click>=8.0<9.0 : devel/py-click@py311
  3. py311-Jinja2>=3.0<4.0 : devel/py-Jinja2@py311
  4. py311-platformdirs>=2.4<5.0 : devel/py-platformdirs@py311
  5. py311-tqdm>=4.0<5.0 : misc/py-tqdm@py311
  6. python3.11 : lang/python311
There are no ports dependent upon this port

Configuration Options:
No options to configure
Options name:
devel_py-shandy-sqlfmt
USES:
python:3.9+
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (2 items)
Collapse this list.
  1. https://files.pythonhosted.org/packages/source/s/shandy_sqlfmt/
  2. https://pypi.org/packages/source/s/shandy_sqlfmt/
Collapse this list.

Number of commits found: 1

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
0.26.0
31 May 2025 14:47:41
commit hash: 5d1b71969afe17de840b19e8910505e706eaa28fcommit hash: 5d1b71969afe17de840b19e8910505e706eaa28fcommit hash: 5d1b71969afe17de840b19e8910505e706eaa28fcommit hash: 5d1b71969afe17de840b19e8910505e706eaa28f files touched by this commit
Hajimu UMEMOTO (ume) search for other commits by this committer
devel/py-shandy-sqlfmt: correct portname

Number of commits found: 1