The tool can list rows in a PostgreSQL database.

The author gives a one-line command using uvx to list rows in a PostgreSQL copy of his blog's database, showing sample output. ✦ AI generated

Simon Willison · Simon Willison's Weblog · 2026-08-12 · original ↗

Here's a one-liner I can use to list the rows in a table in my local PostgreSQL copy of my blog's database: uvx --with 'alchemy-utils[postgresql]' alchemy-utils rows 'postgresql+psycopg://simon@localhost:5432/simonwillisonblog' redirects_redirect The output from that starts like this: [ { "id": 2328, "domain": "simonwillison.net", "path": "2020/May/21/apple-photos-sqlite/", "target": "/2020/May/21/dogsheep-photos/", "created": "2020-05-21T13:03:46.591692-07:00" }, { "id": 3, "domain": "feeds.simonwillison.net", "path": "swn-links", "target": "https://simonwillison.net/atom/links/", "created": "2017-10-01T14:12:54.820729-07:00" } ]

Read full article ↗excerpt · fair-use quotation