SQL Manager for PostgreSQL 7.0 has arrived, and its headline feature is a new AI Assistant. According to the release announcement, this is a major version and marks the start of rolling out AI capabilities across the vendor's database tools, with SQL Manager for PostgreSQL among the first to receive them. The same assistant is also available in SQL Management Studio for PostgreSQL, which ships alongside SQL Manager.
Concrete capabilities in this release include:
- Plain-language query generation: describe what you need and get SQL.
- SQL explanation for existing statements, plus error fixing and optimization suggestions.
EXPLAINplan interpretation to make sense of query execution plans.- Schema diffing: supply two database schemas and receive a list of differences with a ready-to-run migration script.
- Requirement-driven migrations: hand over the current schema plus new business requirements to get a change script.
- File-based SQL analysis: attach someone else's SQL, have it explained, then request modifications.
- Context control: decide how much of the schema the model sees, down to a single table.
- Multiple providers: connect as many as you like via an API key stored encrypted, and switch models directly in the chat.
Ollamasupport for fully self-contained, local operation where data never leaves the machine.
For developers, the notable shift is not just AI assistance but its scoping. Sending schema details to a hosted model is a real concern, and letting teams limit context to a single table—or run entirely against Ollama—turns that into a configurable trade-off rather than a fixed risk. The migration-script and diffing features also target a common, error-prone task, potentially reducing manual comparison work. Teams evaluating AI tooling for PostgreSQL should note that provider flexibility and encrypted key storage lower the barrier to trying multiple models.
Source: https://www.postgresql.org/about/news/sql-manager-for-postgresql-70-meet-the-ai-assistant-3379/