PgAdmin 4 9.13 Adds AI Assistant Panel to Query Tool
PgAdmin 4 9.13 AI Assistant Integration
PgAdmin 4 version 9.13 adds an AI Assistant panel to its Query Tool, enabling SQL generation from natural language input when AI services are configured. This feature appears as a tab within the SQL Editor panel alongside existing History and Scratch Pad tabs.
Query Tool Features
The Query Tool remains a feature-rich SQL environment that allows:
- Execution of arbitrary SQL commands and ad-hoc queries
- Editing of updatable SELECT query result sets
- Display of current connection and transaction status
- Export of output panel data to CSV files
- Review of SQL execution plans in text, graphical, or table formats (similar to explain.depesz.com)
- Viewing analytical information about SQL statements
- Opening multiple Query Tool instances in individual tabs
Workspace Layout Changes
Version 9.13 introduces a Workspace layout that provides a distraction-free environment for the Query Tool. Key changes include:
- Welcome page opens by default when accessing Query Tool workspace
- All Query Tool and View/Edit Data tabs open within the Query Tool workspace
- Ability to connect to ad-hoc servers not registered in Object Explorer
- Connection parameters include: Server Name, Host name/address, Port, Database, User, Password, Role, and Service fields
- Connect & Open Query Tool button launches the tool with provided server details
This differs from the classic UI where users must connect to a database server and navigate to the database node before using the Query Tool.
Panel Organization
The Query Tool features two main panels:
- Upper panel (SQL Editor): Contains tabs for entering/editing queries, History tab for session queries, Scratch Pad for text snippets, and the new AI Assistant tab
- Lower panel (Data Output): Displays query result sets, execution plan information, server messages, and asynchronous notifications
If the Scratch Pad is closed, it can be reopened by right-clicking in the SQL Editor or other panels and adding a new panel.
📖 Read the full source: HN AI Agents
👀 See Also
SoulPrint: Local Tool for Searching Claude and ChatGPT History Together
SoulPrint is an open-source Python tool that imports conversation exports from Claude (.json) and ChatGPT (.zip) into a local SQLite archive, enabling full-text search across both providers simultaneously with BM25 ranking and highlighted snippets.
AgentCrawl Update Adds Critical Crawler Features and Enhancements
AgentCrawl's latest update introduces features like robots.txt compliance, disk caching, resumable crawls, and structured metadata extraction, turning it into a more robust and production-ready tool.
Marmy: A Self-Hosted Mobile App for Managing Multiple AI Coding Agent Sessions
Marmy is an open-source, self-hosted tool built with Claude Code that lets you manage multiple AI coding agent sessions from your phone. It features a Rust agent for your machines, an iOS app, file browsing with syntax highlighting, push notifications, and a manager-agent architecture.
Building a Full Production App with Claude: What Actually Worked and What Didn't
A senior backend dev with zero Flutter experience shipped a full production app (iOS + Android) using Claude as primary tool over 2.5 months. Details the workflow, failures, and why tests were the quality gate.