SQL Manager for PostgreSQL 7.0: meet the AI Assistant

This is a major release, and the headline feature is our new AI Assistant. We're starting to roll out AI capabilities across our database tools, and SQL Manager for PostgreSQL is the first to get them. It's also available in SQL Management Studio for PostgreSQL, which ships with SQL Manager.

You'll find all the AI Assistant features you'd expect: write a query from a plain-language description, explain existing SQL, fix errors, optimize, make sense of an EXPLAIN plan.

But you can also take on bigger jobs:

• Give it two database schemas and get a list of the differences along with a ready-to-run migration script.
• Hand it your current schema along with new business requirements and get a script that makes the changes.
• Attach someone else's SQL as a file, have it explained, then ask for changes.

Here's the key part: you decide how much of the schema the model sees, down to a single table. You stay in full control of exactly what context goes to the model.

Connect as many providers as you like — all it takes is an API key (stored encrypted), and you can switch models right in the chat. Need to stay completely self-contained? It works with Ollama, so your data never leaves your machine.

How the AI Assistant works in SQL Manager for PostgreSQL

Download SQL Manager for PostgreSQL