When I got the update I looked through the settings and there appears to be no way to disable it. I do not want AI anywhere near my database. I only use it for testing/staging at least so I should hopefully not have to worry about it wrecking production.
What's the danger? It can see the schemas to help it generate the queries but it can't run anything on its own. Also you have to give the application credentials to an AI provider for the feature to work. So, you can just not do that.
There is no need of potential dangers to not want to have non-deterministic features in an application.
The docs suggest that you can set the default provider to "None" to disable AI features: https://www.pgadmin.org/docs/pgadmin4/9.13/preferences.html#...
Note: AI features must be enabled in the server configuration
in config.py for these preferences to be available.I did not enable this and yet I got the panel in the UI.
It is nice that they have the default set to "None". However to have this feature in pgAmdin is as distraction from the project.
If it is just calling API anyway, then I don't want to have this in my db admin tool. It also expose surface area of potential data leakage.
Worth pointing out that Postgres is perfectly usable without an admin dashboard at all
Did you miss this:
"This feature requires an AI provider to be configured in Preferences > AI."
And then you have to supply an API key (see here https://www.pgedge.com/blog/ai-features-in-pgadmin-configura... )
You don't get AI for free!
Why do you do in production?