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)
