This is a solid update. Postgres support is huge, especially for catching those missing FK indexes that usually don't surface until you're under heavy load. I'm curious to see how the JSON vs JSONB analysis holds up on some of my messier schemas. Nice work on this!
π DBStan Now Supports PostgreSQL
Hi everyone π
I wanted to share a quick update on DBStan β the database analysis tool for Laravel.
Weβve just added support for PostgreSQL π
π Whatβs New
DBStan can now analyze PostgreSQL databases and detect issues like:
Missing indexes (e.g., on foreign keys) Incorrect or missing relationships Risky nullable columns Inefficient data types (like using JSON instead of JSONB)
π‘ Why It Matters
PostgreSQL is widely used for high-performance and complex applications, but database issues can go unnoticed.
π DBStan helps catch them early β before they impact performance.
βοΈ How to Use
Just switch your DB connection:
DB_CONNECTION=pgsql
Run:
php artisan dbstan:analyze
Thatβs it β DBStan automatically detects PostgreSQL.
π― Goal
To provide consistent and reliable database analysis across both MySQL and PostgreSQL, helping developers build optimized and production-ready applications.
Iβd really appreciate your feedback, suggestions, or contributions π
Thanks!
Please or to participate in this conversation.