TL;DR

Changes to SQL

• Processing for queries containing INTERSECT has been added. This enables the users to find common entries from different sets of data.
• Fixed error with show columns from information_schema.{table}. This provides users with the correct information about the table's structure and content.
• Improved error message formatting for the database. This will give users a clearer understanding of any issues that arise during the database operation.
• Updated config options for file upload via URL. This change gives users more flexibility and more secure methods to upload files.

Changes to Integrations

• Fixed a bug regarding subscription in PostgreSQL. This fix will result in better and more reliable mechanisms for real-time syncing and publishing data.
• Important fixes were done on Big Query Data Catalog enhancing seamless integration with Google's BigQuery.

Changes to Knowledge Bases

• Notable improvements have been made in terms of functionality and performance of Knowledge Bases (KB). Including search and evaluate features improvements, metadata updates, filter restriction by unknown metadata keys, algebra operations, and more. Such changes are expected to improve user experience with KB in terms of search accuracy, metadata handling, and manipulation.
• The creation agent now supports wildcards in table/KB names which increases usability, efficiency, and flexibility in defining database schemas.

Bug Fixes and Improvements

• The agent can now handle wrong quoting table names more effectively. This reduces the error rate when handling table names.
• Temporary disable huggingface_handler. This might contribute to better resource allocation and overall performance.
• Parameters in Google Gemini model examples have been updated for consistency which led to improved model performance and usability.

Changes to Documentation

• A considerable amount of updates have been provided on the documentation end. Updates include Docker installation with APIs, mindsDB variables, evaluate docs, Data Catalogue, and more. This strengthens the reference for users and helps them understand all aspects of MindsDB in better detail.

What's Changed

• Temporary disable huggingface_handler by @StpMax in #11155
• Added processing for queries containing INTERSECT by @StpMax in #11052
• fix: update parameter names in Google Gemini model examples for consistency by @PriyanshuPz in #11165
• Data Catlogue Docs by @ZoranPandovski in #11131
• Changes to test_mysql_api.py based on db driver features by @StpMax in #11175
• docs -- alter view by @martyna-mindsdb in #11168
• Fix KB evaluation: evaluation didnt make search in KB by @ea-rus in #11188
• Create agent: support wildcards in tables / KB names by @ea-rus in #11067
• Adding keyword search by @fshabashev in #11114
• Create agent: data parameter by @ea-rus in #11039
• KB Evaluate: fix when base_url is empy string by @ea-rus in #11192
• KB algebra by @ea-rus in #11132
• Fix Subscribe in PostgreSQL by @ZoranPandovski in #11150
• Big Query Data Catalog fixes by @ZoranPandovski in #11177
• KB metadata keys: service values are underscored by @ea-rus in #10939
• KB restrict filter by unknown metadata keys by @ea-rus in #11019
• KB: set created_at and updated_at in metadata by @ea-rus in #10950
• Fix show columns from information_schema.{table} by @StpMax in #11058
• Better db error message formatting by @StpMax in #11200
• Agent: handle wrong quoting table names by llm by @ea-rus in #11191
• New config options for file upload via URL by @StpMax in #11179
• Use parser tests with the same version as installed version by @ea-rus in #11215
• Improve MCP tools description by @StpMax in #11218
• feat: add git feature to devcontainer configuration by @parthiv11 in #10398
• update static IPs to new cluster ones by @hamishfagg in #11224
• Fix KB reranker: show error, support gemini by @ea-rus in #11229
• Create agent: llm parameters as dict by @ea-rus in #11043
• docs -- docker installation with apis by @martyna-mindsdb in #11214
• docs -- mindsdb variables by @martyna-mindsdb in #11216
• docs -- changed title of evaluate docs by @martyna-mindsdb in #11180
• docs -- kb via rest api by @martyna-mindsdb in #11189
• docs -- updated dbeaver conn page by @martyna-mindsdb in #11237

New Contributors

• @PriyanshuPz made their first contribution in #11165

Full Changelog: v25.6.4.0...v25.7.1.0