VS Code Marketplace 0.4.0

Powerful PostgreSQL
Management Inside VS Code

Write SQL, manage databases, and leverage AI—all without leaving your editor. Interactive notebooks, live dashboards, and intelligent assistance in one seamless extension.

⬇️ Install Now ✨ Explore Features
1
✨ Ask AI Optimize Explain
-- Real-time database insights
SELECT
  date_trunc('day', created_at) AS day,
  COUNT(*) AS users,
  SUM(amount) AS revenue
FROM orders
WHERE created_at >= NOW() - INTERVAL '7 days'
GROUP BY day ORDER BY day;
✓ 7 rows in 45ms
📥
Downloads
⭐
Rating
🚀
Latest

Your Database Workflow

Connect, Explore, Query, Analyze—all in one place

🔐

Connect

Secure credential storage with multiple simultaneous connections

→
🌳

Explore

Navigate schemas, tables, views, functions with ease

→
📝

Query

Write interactive SQL notebooks with AI assistance

→
📊

Analyze

Monitor performance and export results instantly

Everything You Need

Comprehensive database management tools built for modern development

🔐

Secure Connections

Enterprise-grade security for your database credentials.

  • VS Code SecretStorage encryption
  • Multiple simultaneous connections
  • One-click connect/disconnect
  • Connection string import
📊

Live Dashboard

Real-time database metrics and performance monitoring.

  • Active connection monitoring
  • Database size tracking
  • Running query management
  • Cache hit ratio analysis
📓

SQL Notebooks

Interactive notebooks with rich output and AI assistance.

  • Multi-cell query execution
  • AI-powered suggestions
  • Tabular result display
  • Export to CSV/Excel
🌳

Database Explorer

Intuitive tree view of your entire database structure.

  • Tables, Views, Functions
  • Materialized Views
  • Types & Extensions
  • Roles & Permissions
⚙️

Advanced Operations

Complete CRUD operations and schema management.

  • View, Edit, Insert, Update, Delete
  • Script generation
  • Table properties & constraints
  • VACUUM, ANALYZE, REINDEX
⚡

Developer Tools

Built for speed with integrated workflow tools.

  • GitHub Copilot integration
  • IntelliSense completions
  • Keyboard shortcuts
  • PSQL terminal access
✨ AI-Powered

Intelligent SQL Assistance

Leverage multiple AI providers to write, optimize, and debug faster

💡

Smart Completions

Context-aware SQL suggestions with table & column awareness

🔍

Query Explanation

Understand complex queries with plain English explanations

⚡

Performance Tips

Get suggestions to improve query performance automatically

🛡️

Error Detection

Syntax and logical error detection with fixes

📄

Query Generation

Describe what you need in natural language, let AI do the heavy-lifting

🗂️

Schema Understanding

The model understands your database schema for accurate suggestions through schema attachments

💬 Natural Language → SQL Make AI work for you...
You: "Show me top 10 @public.customers by revenue in the last 30 days"
✨ AI Generated:
SELECT
  c.id, c.name,
  SUM(o.amount) AS total
FROM
  @public.customers c
JOIN orders o ON c.id = o.customer_id
WHERE o.created_at >= NOW() - INTERVAL '30 days'
GROUP BY c.id, c.name
ORDER BY total DESC LIMIT 10;