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](https://www.sqlmanager.net/ai-assistant)

[Download SQL Manager for PostgreSQL](https://www.sqlmanager.net/products/postgresql/manager/download)