Operations | Monitoring | ITSM | DevOps | Cloud

PostgreSQL IDE + AI Assistant | dbForge Studio for PostgreSQL

Manage the full PostgreSQL database lifecycle from one AI-powered IDE. dbForge Studio for PostgreSQL brings together database design, development, and administration, as well as data management, analysis, reporting, and extensive automation. Additionally, the integrated AI Assistant generates, explains, optimizes, and troubleshoots SQL queries directly in the Studio. It supports on-premises PostgreSQL databases and related cloud services such as Supabase, Heroku, Amazon Redshift, and TimescaleDB.

MCP Servers 1.1.0 Add Flexible HTTP Routing and CLI Connection Management

We are pleased to announce the release of MCP Servers 1.1.0, bringing new configuration options for HTTP-based deployments and expanded command-line capabilities for managing database connections. The new version makes it easier to control how MCP Servers are exposed over HTTP, host multiple MCP Servers under a single hostname, and configure connections directly from the command line.

dbForge Studio for PostgreSQL + AI Assistant: Features and Use Cases

PostgreSQL database development involves much more than writing and executing queries. Developers build applications, DBAs maintain database performance and reliability, analysts turn raw data into insights, and DevOps teams automate database delivery through CI/CD pipelines. In this video, you will see how dbForge Studio for PostgreSQL brings database development, management, data analysis, reporting, and automation into a single AI-powered PostgreSQL IDE.

Will AI agents replace database IDEs? The future of database development

AI is already good at writing SQL, which is why people keep asking whether AI agents will replace database IDEs. But letting an agent work on a production database is still a much bigger leap. In tests reported by BIRD, a text-to-SQL benchmark built from 95 real databases across 37 professional domains, human experts reached 92.96% execution accuracy. The best single-model entry reached 80.04% in June 2026. The model failed roughly one task in five; the humans, about one in fourteen.

13 best practices for database development in Visual Studio 2026

Database development rarely breaks all at once. It happens through small changes that seem harmless at the time. Someone adds a column directly to the shared database. A stored procedure gets fixed in production but not in the project. An index is created in staging and never added anywhere else. Everything looks fine until the next release. Then the differences start showing up, and nobody is quite sure which version of the schema is correct.

SSIS Data Flow Components Update Brings Expanded API and Data Source Support

The latest release of Devart SSIS Data Flow Components expands support for cloud applications and databases with new objects and fields, updated API and metadata support, and improved authentication and data access capabilities across multiple connectors.

Devart Excel Add-ins Extend Connectivity With New API, Security, and Data Support

We are thrilled to announce an update to our Excel Add-ins, bringing expanded support for popular cloud services and databases. The release introduces new objects, fields, API capabilities, and authentication options for BigCommerce, FreshBooks, HubSpot, NetSuite, QuickBooks Online, Zoho CRM, Oracle, MySQL, and PostgreSQL.

dbForge Studio for SQL Server: AI-Powered IDE for the Full Database Lifecycle

SQL Server development involves much more than writing and executing queries. There are other core aspects such as database design, debugging, data management, performance analysis, administration, deployment, and workflow automation. In this video, you will see how dbForge Studio for SQL Server lets you manage the entire database lifecycle from a single AI-powered SQL Server IDE. Instead of switching between separate tools for SQL coding, database design, test data generation, comparison, reporting, and administration, you can use one application for everything.

MySQL Query Optimization With dbForge Query Profiler

Learn how to optimize SQL queries in MySQL with Query Profiler in dbForge Studio for MySQL. This video shows how to monitor query execution plans , track resource consumption, identify performance bottlenecks , and validate query optimization results. Query Profiler helps developers, DBAs, and database engineers analyze query execution, find slow operations , review session statistics, compare profiling results, and improve MySQL database performance .