---

📸 Screenshots

🎥 Video Guides

1. Quick Setup

2. More Settings

3. AI Assistant

4. AI Copilot

5. Dashboard

6. DB Operations

7. Power Editor

8. More Features

---

✨ Key Features

Feature	Description
🔌 Secure Connections	Manage multiple connections with VS Code SecretStorage encryption
🛡️ Connection Safety	Environment tagging (🔴 PROD, 🟡 STAGING, 🟢 DEV), read-only mode, query safety analyzer
📊 Live Dashboard	Real-time metrics, active query monitoring, and performance graphs
📓 SQL Notebooks	Interactive notebooks with rich output, AI assistance, and export options
💾 Saved Queries	Tag-based organization, AI metadata generation, connection context restoration, edit & reuse
🌳 Database Explorer	Browse tables, views, functions, types, extensions, roles, and FDWs
🛠️ Object Operations	Full CRUD operations, scripts, VACUUM, ANALYZE, REINDEX
📊 Table Intelligence	Profile, activity monitor, index usage analytics, definition viewer
🔍 EXPLAIN CodeLens	One-click EXPLAIN/ANALYZE with results in notebooks
🛡️ Auto-LIMIT	Automatic query protection with configurable row limits (default 1000)
🌍 Foreign Data Wrappers	Manage foreign servers, user mappings, and tables
🤖 NexQL Free AI	Zero-config AI assistant — Smart/Engineer/Architect tiers, no API keys needed
🔌 MCP Server	Built-in MCP server — expose your database to Copilot, Cursor, Claude Desktop & more
⌨️ Developer Tools	IntelliSense, keyboard shortcuts, PSQL terminal access
📤 Export Data	Export query results to CSV, JSON, or Excel formats
📉 Large result streaming	Optional sliding-window cursor mode for big SELECTs — bounded memory, scroll to fetch
🔢 Binary columns	Configurable bytea display (hex / PostgreSQL / JSON debug)
🤖 SQL Assistant	Regenerate last reply or resend from an earlier user message; prefill when attaching context

---

🎯 Why NexQL?

🎨 Modern Interface Beautiful, intuitive UI designed for developers Real-time dashboard with live metrics Context-aware operations Seamless VS Code integration	⚡ Powerful Features Interactive SQL notebooks 🤖 AI-powered Copilot & agentic support Advanced query management Complete CRUD operations
🔐 Secure & Reliable VS Code SecretStorage for credentials Environment tagging & read-only mode Query safety analyzer with risk scoring Auto-LIMIT protection Transaction support	📊 Performance Intelligence Table profiling with size breakdown Real-time activity monitoring Index usage analytics Bloat detection & warnings EXPLAIN CodeLens for optimization
🚀 Developer Friendly 🤖 NexQL Free AI — zero-config, no API key needed 🔌 Built-in MCP server for Copilot, Cursor, Claude Desktop Keyboard shortcuts IntelliSense support PSQL terminal integration

---

📋 Feature Matrix

Area	NexQL v2.2.0	Notes
Core PostgreSQL object operations	✅	Tables, views, mat views, functions, roles, extensions, FDWs, and more
AI-assisted SQL workflows	✅	Generate, optimize, explain, analyze, and notebook handoff
NexQL Free AI (zero-config)	✅	Smart / Engineer / Architect tiers, no API keys required
MCP Server	✅	Expose DB tools to Copilot, Cursor, Claude Desktop, and more
Production safety controls	✅	Read-only mode, query risk scoring, confirmation prompts, Auto-LIMIT
Real-time monitoring dashboard	✅	Activity and performance telemetry in VS Code
Interactive SQL notebooks	✅	Native .pgsql notebook workflow
Data Import	✅ Free	No usage cap — unlimited across all tiers
Backup & Restore	✅ Free	No usage cap — unlimited across all tiers
Database Indexing	✅ Free	Build, auto-index, semantic index — unlimited across all tiers
In-grid editing parity with desktop IDEs	⚠️ Partial	Planned enhancements in upcoming releases
ERD/schema visualization parity	⚠️ Partial	Under active expansion

---

⚠️ Known Limitations (v2.2.0)

• In-grid editing is currently more limited than full desktop DB IDEs.
• ERD/schema visualization is available but not yet feature-complete.
• Some advanced PostgreSQL admin workflows are partial and are scheduled for incremental updates.
• NexQL Free AI gateway is in Beta and may be subject to quota adjustments.

---

🌐 Works With Your Postgres — Wherever It Runs

NexQL connects to any PostgreSQL-wire-compatible database:

• ✅ PostgreSQL 12–17 — self-hosted, Docker, on-prem
• ✅ Neon — serverless Postgres (use the direct endpoint, SSL require)
• ✅ Supabase — direct or session pooler connections
• ✅ TimescaleDB & Timescale Cloud — 100% compatible (Postgres extension)
• ✅ YugabyteDB (YSQL) — distributed Postgres, port 5433
• ✅ AWS RDS / Aurora, Google Cloud SQL / AlloyDB, Azure Database for PostgreSQL

See the compatibility guide for per-platform connection settings and caveats.

---

🌳 Database Explorer

Navigate your database with an intuitive hierarchical tree view:

📁 Connection
└── 🗄️ Database
    └── 📂 Schema
        ├── 📊 Tables
        ├── 👁️ Views
        ├── 🔄 Materialized Views
        ├── ⚙️ Functions
        ├── 🏷️ Types
        ├── 🌍 Foreign Data Wrappers
        ├── 🧩 Extensions
        └── 👥 Roles

---

💾 Saved Queries Library

Organize, manage, and reuse your most important queries with intelligent tagging and context preservation.

Core Capabilities

• 🏷️ Tag-Based Organization — Group queries by purpose for instant discovery
• 🔗 Connection Context — Queries remember their original connection, database, and schema
• 📓 One-Click Reopening — Restore queries with full context in a new notebook
• ✏️ In-Place Editing — Modify queries without creating duplicates
• 🤖 AI Metadata Generation — Auto-generate titles, descriptions, and tags
• 📊 Rich Metadata Display — See creation date, usage count, database, and connection at a glance

---

🤖 AI-Powered Assistance

Leverage AI to write, optimize, and debug your queries faster.

🚀 NexQL Free AI — Zero-Config (Default, v2.2.0)

No API keys, no provider accounts, no setup. NexQL Free AI is the default AI provider, powered by managed models behind a secure gateway proxy:

• 🧠 Smart (free) — Daily-use AI for queries, explanations, and schema help. ~600K tokens/month.
• 🔧 Engineer (Sponsor · $2/mo) — Advanced model for complex optimization and migrations. ~3M tokens/month.
• 🏗️ Architect (Singularity · $9/mo) — The best AI for database engineering. ~10M tokens/month.

🔌 MCP Server — New in v2.2.0

NexQL now exposes your connected PostgreSQL databases as a Model Context Protocol (MCP) server, letting GitHub Copilot, Cursor, Claude Desktop, and any other MCP-compatible AI agent use NexQL's live schema tools:

• Schema discovery (list_schemas, list_objects, describe_object, search_schema)
• Safe SQL execution (run_select, explain_query)
• Join-path inference (get_join_path)
• Performance analytics (get_table_stats, get_index_usage)

Enable via NexQL Settings → Preferences. VS Code's Copilot discovers NexQL automatically — no manual config required.

• Smart Completions — Context-aware SQL suggestions
• Query Explanation — Understand complex queries in plain English
• Query Optimization — Get performance improvement suggestions
• Error Detection — Real-time syntax and logical error detection
• Natural Language to SQL — Describe what you need, let AI write the SQL

🛡️ Safe AI Execution

NexQL provides a Safe Execution Model for AI interactions.

• Human-in-the-Loop: AI generates the code, but it is never executed automatically. You review it in a notebook cell first.
• Context Control: You decide which tables the AI can see.

Supported AI Providers:

• NexQL Free AI (default — no API key required)
• GitHub Copilot (VS Code LM)
• GitHub Models (GitHub account sign-in)
• OpenAI (GPT-4.1, o4-mini, and more)
• Anthropic Claude (Sonnet 4, Haiku, and more)
• Google Gemini (2.5 Flash, 2.5 Pro)
• Ollama / LM Studio / Custom OpenAI-compatible endpoints

---

🎨 Rich Data Visualization

Transform your data into insights without exporting to Excel.

Instantly Visualize Results

• One-Click Charts: Create Bar, Line, Area, and Pie charts from any query result.
• Customizable: Adjust log scales, use varied point styles, and control fill opacity.
• Modern VFX: Enable Glow and Blur effects for stunning, dashboard-ready visuals.
• Custom Endpoints

---

🚀 Quick Start

Installation

1. Open VS Code → Press Ctrl+Shift+X
2. Search for NexQL
3. Click Install

Or install via command line:

code --install-extension ric-v.postgres-explorer

First Connection

1. Click the PostgreSQL icon in the Activity Bar
2. Click Add Connection or use Ctrl+Shift+P → PostgreSQL: Add Connection
3. Enter your connection details and click Save
4. Click on your connection to connect and start exploring!

---

📊 Complete Database Operations

Object Type	Operations
📊 Tables	View, Edit, Insert, Update, Delete, Truncate, Drop, VACUUM, ANALYZE, REINDEX
👁️ Views	View Definition, Edit, Query Data, Drop
🔄 Materialized Views	Refresh, View Data, Edit, Drop
⚙️ Functions	View, Edit, Call with Parameters, Drop
🏷️ Types	View Properties, Edit, Drop
🌍 Foreign Data Wrappers	Create/Drop Server, User Mappings, Import Schema
🔗 Foreign Tables	View, Edit, Drop
🧩 Extensions	Enable, Disable, Drop
👥 Roles	Grant/Revoke Permissions, Edit, Drop

---

⌨️ Keyboard Shortcuts

Shortcut	Action
Ctrl+Enter	Execute current cell
Shift+Enter	Execute and move to next
F5	Refresh current item
Ctrl+Shift+P	Command palette

---

📚 Resources

• 📖 Full Documentation
• 🐛 Report Issues
• 💡 Request Features
• ⭐ Star on GitHub

---

📝 License

This extension is licensed under the MIT License.

---