Devart

08/31/2026

💡 Smarter Query Routing for AI SQL Assistants: How to Cut Costs Without Sacrificing Quality

Victor Horlenko, Head of AI Innovations at Devart, shares his perspective in Unite.AI's latest piece on AI SQL cost optimization.

He breaks down why sending every SQL query through the same frontier AI model is like using rocket fuel to fetch a grocery list. Smart routing sorts queries by complexity and sends each to the right-sized model, cutting inference costs by 40 to 70% without lowering output quality.

Check the article ➡️ https://www.unite.ai/ai-sql-query-routing-cost-optimization/

🔧 These routing patterns come directly from the experience of developing schema awareness in dbForge AI Assistant, where accurate classification depends on providing the model with schema metadata so it can correctly assess a query's complexity.

✅ Explore dbForge AI Assistant: https://www.devart.com/dbforge/ai-assistant/

It generates, explains, and optimizes SQL using your actual schemas.

08/27/2026

Two ComponentSource Awards for Devart in 2026! 🎉

Devart has been named a Top 25 Publisher in the ComponentSource Awards 2026, while dbForge SQL Complete has earned a place among the Top 100 Products.

Recognition across both publisher and product categories highlights the trust developers and database professionals continue to place in our tools, as well as the work our teams put into improving them year after year.

We are grateful to our customers, partners, and everyone at Devart who contributes to that progress.

🔗 Publisher Awards:
https://www.componentsource.com/publisher/bestselling-publisher-awards-2026

🔗 Product Awards:
https://www.componentsource.com/publisher/bestselling-product-awards-2026

08/26/2026

🔍 Top 10 MySQL Management Tools for 2026

Choosing a MySQL management tool is rarely a real decision. Most teams just download whatever's free and stick with it. That works until you need to compare schemas, run backups, or profile queries, and the tool can't keep up.

📖 Check out the full comparison of 10 top MySQL GUI tools: https://medium.com//top-10-mysql-management-tools-for-2026-013e4eb56d4d

The review ranks dbForge Studio for MySQL first, pointing to AI-powered query generation and optimization, Query Profiler, MySQL Debugger, as well as schema and data comparison with synchronization, all in one tool.

⚡ Try the AI-powered dbForge Studio for MySQL for free: https://www.devart.com/dbforge/mysql/studio/download.html

Once you get started with the Studio, you won't need to replace it. The Studio is built for workflows of all levels.

08/25/2026

🧩 How to Create Pivot Tables in PostgreSQL

PostgreSQL has no built-in PIVOT operator. To turn rows into a cross-tab summary, you're stuck writing crosstab() with predefined output columns, hand-building conditional aggregation, or generating dynamic SQL when categories aren't known in advance.

📖 See how it works: https://www.devart.com/dbforge/postgresql/studio/pivot-tables-in-postgresql.html

dbForge Studio for PostgreSQL turns that into a drag-and-drop workflow: run a query, send the results to a pivot table, drag fields to reorganize rows and columns, filter and group data, and generate charts, all without rewriting a single query.

🐘 Download the AI-powered dbForge Studio for PostgreSQL: https://www.devart.com/dbforge/postgresql/studio/download.html

dbForge Studio's pivot tables give you the flexibility to summarize large datasets and chart them, whether that's the full picture or just a slice of it.

08/21/2026

🧠 Index-Aware AI SQL Optimization in dbForge

Frank, from Learning and Technology with Frank, tested the query optimization capabilities of dbForge around one question: can AI-generated SQL be optimized for your actual database structure, not just syntactically correct?

🍿 Watch the full walkthrough: https://youtu.be/BMFCbA-T764

The demo shows how dbForge AI Assistant reads database index metadata, generates T-SQL from natural language, explains inherited or unfamiliar queries, and suggests optimizations based on the indexes that actually exist in your database.

⚡ Download the AI-powered dbForge Studio for SQL Server: https://www.devart.com/dbforge/sql/studio/download.html

It's a feature-rich IDE for writing, optimizing, and managing your SQL Server and Azure SQL databases.

Can AI write SQL that is not only correct, but also optimized for y...

08/19/2026

⚖️ AI Assistants in Databases: Speed vs. Reliability

AI can write a query, explain an ex*****on plan, or draft documentation in seconds. That speed is why 84% of developers are already using or planning to use AI tools.

But speed isn't the same as reliability. AI doesn't actually know your schemas, and a wrong-but-plausible query doesn't fail loudly, it passes silently into whatever comes next. That's the trade-off worth understanding before you lean on AI for anything that matters.

👉 See exactly where AI speeds you up and where it needs a human check: https://hackernoon.com/ai-assistants-in-databases-speed-vs-reliability

The takeaway isn't to slow down AI everywhere. It's to match the speed to the risk. dbForge AI Assistant brings that balance into dbForge solutions: it works from live metadata in your connected database, tables, column types, relationships, so SQL generation, optimization, and error troubleshooting start from your actual schema instead of a guess.

✅ Explore the AI-powered dbForge ecosystem: https://www.devart.com/dbforge/

Schema-aware AI across SQL Server, MySQL, MariaDB, Oracle, and PostgreSQL, so speed never comes at the cost of trust.

08/18/2026

⚔️ dbForge SQL Complete vs Redgate SQL Prompt

The default IntelliSense in SSMS and Visual Studio handles the basics. Formatting, refactoring, debugging, and AI-assisted troubleshooting are where coding add-ins actually start to differ.

📊 See the full feature-by-feature comparison: https://www.devart.com/dbforge/sql/sqlcomplete/redgate-sql-prompt-apexsql-complete-alternatives.html

dbForge SQL Complete covers the same code completion and formatting ground as other tools in this comparison, then adds SQL error explanations, an AI chat, a full T-SQL debugger, and CLI-powered search for invalid objects across your database.

⚡ Get the AI-powered dbForge SQL Complete and see the difference in your own SSMS or Visual Studio workflow: https://www.devart.com/dbforge/sql/sqlcomplete/download.html

This is the ultimate tool that helps you write cleaner SQL, work more efficiently, and maintain consistency.

08/17/2026

🎥 AI for PostgreSQL: Write SQL Faster With dbForge Studio

Here's a demo by Trevoir Williams, software engineer and instructor, showcasing dbForge Studio for PostgreSQL and dbForge AI Assistant through a hands-on test built around one question: can AI speed up writing SQL while keeping the developer in control of the final query?

🍿 Watch the full walkthrough: https://youtu.be/IDQ5L26mlw4

The demo covers exploring PostgreSQL objects and table data, writing and running SQL queries, generating queries from natural-language prompts, and using schema context so AI Assistant's suggestions and explanations actually match the database in front of you.

⚡ Try the AI-powered dbForge Studio for PostgreSQL for free: https://www.devart.com/dbforge/postgresql/studio/download.html

With dbForge Studio, your schema, SQL editor, and AI Assistant work from the same context.

Can AI help you write PostgreSQL queries faster while keeping you i...

08/14/2026

Devart Turns 29 🎉! Celebrate With 20% Off Everything!

It’s our birthday, and we’re sharing gifts. From August 14 to August 31, get 20% off every Devart product — database management, data connectivity, and productivity tools trusted by IT teams worldwide.

29 years, 140+ products, 500K users, one of the best discounts of the year.

Claim your 20% discount → https://www.devart.com/happy-birthday.html

08/13/2026

📅 SQL Server Convert String to Date: CAST, CONVERT, and TRY_CONVERT Examples

Dates stored as text strings in CSV or JSON files look harmless, until you try to sort, filter, or calculate with them, and SQL Server throws an error or silently misreads the format.

📖 Check the full guide with examples: https://www.devart.com/dbforge/sql/studio/sql-server-convert-string-to-date.html

The guide breaks down when to use CAST for simple ANSI-standard conversions, CONVERT for style-code-based formatting like DD/MM/YYYY or ISO 8601, and TRY_CONVERT for safely handling dirty or user-entered data without breaking the query. All examples run directly in dbForge Studio for SQL Server, where the AI Assistant can also explain conversion errors and suggest fixes for mismatched style codes or regional date formats.

⚡ Get dbForge Studio for SQL Server for a free trial: https://www.devart.com/dbforge/sql/studio/download.html

It's an AI-powered IDE that supports the full database development lifecycle, from SQL coding and ex*****on to version control and automation.