Database Linting and Analysis for PostgreSQL

Re:Database Linting and Analysis for PostgreSQL by neves on Sunday October 12, 2025 @10:28PM (#45564149)

Looks nice. Do you know any similar tools that work for other databases?

[ Parent | on HN ]

Re:Database Linting and Analysis for PostgreSQL by evanelias on Monday October 13, 2025 @12:11PM (#45570009)

Schema management tools often include built-in linters. I added a linter engine to my MySQL/MariaDB schema management tool Skeema back in 2019 and it proved to be a popular feature [1]. A couple more recent entrants in this space include ByteBase [2] and Atlas [3].

When selecting a linter, I'd just recommend ensuring the author(s) are deeply experienced in your particular DBMS. Otherwise they tend to cargo-cult bad advice that is either out-of-date, or only makes sense for some other DBMS. And nowadays, AI hallucinations are another source of nonsensical linters.

[1] https://www.skeema.io/docs/features/safety/

[2] https://docs.bytebase.com/sql-review/review-rules

[3] https://atlasgo.io/versioned/lint

[ Parent | on HN ]

Re:Database Linting and Analysis for PostgreSQL by rotemtam on Wednesday October 15, 2025 @08:45AM (#45591568)

Thanks for the mention evan!

[ Parent | on HN ]

Re:Database Linting and Analysis for PostgreSQL by tianzhou on Monday October 20, 2025 @02:18AM (#45640555)

Appreciate the Bytebase shoutout! Skeema has definitely been an inspiration.

[ Parent | on HN ]