Neon VS Code Extension

The Neon extension lets you connect to any Neon branch and manage your database directly in your IDE. Available for VS Code, Cursor, and other VS Code-compatible editors, you can browse schemas, run queries, edit table data, and get connection strings, without leaving your editor.

With the Neon extension, you can:

• Connect to projects and branches
  The extension automatically detects valid Neon connection strings in your code.
• Browse your database
  Use a clean tree view showing databases, schemas, tables, views, sequences, and relationships.
• Manage databases and tables
  Create and manage databases, schemas, and tables directly in your IDE.
• Run queries with SQL Editor
  Write and execute queries against your selected database. View and sort results, and export data if needed.
• Edit data with Table Data Editor
  View, edit, insert, and delete rows in a spreadsheet-like interface. Import and export tables in CSV, JSON, or SQL formats.
• Enable AI-powered features
  Automatically configure the Neon MCP Server so you can manage projects, branches, and databases from your AI chat.

• VS Code 1.85.0+, Cursor, or other VS Code-compatible editor.
• A Neon account.

Once connected, the extension provides a comprehensive Database Explorer in the sidebar that lets you browse your database structure with an intuitive tree view:

• Databases: All available databases in your connected branch.
• Schemas: Database schemas organized in a tree structure.
• Tables & Views: All tables and views with their column definitions.
• Sequences: Database sequences.
• Data Types: Column data types, constraints, and relationships.
• Primary Keys: Clearly marked primary key columns.
• Foreign Keys: Visual indicators for foreign key relationships.

• Right-click any table to access quick actions:

  • Query Table: Opens a pre-filled SELECT * query in the SQL Editor.
  • View Table Data: Opens the table data in an editable spreadsheet view.
  • Truncate Table: Remove all rows from a table.
  • Drop Table: Delete the table entirely.

• Right-click databases or schemas for management operations.

• Refresh the schema view to see the latest structural changes.

• Expand/collapse database objects to focus on what you need.

The schema view automatically updates when you switch between branches, so you always see the current state of your connected database.

Right-click databases, schemas, or tables to access management operations:

• Create and drop databases and schemas: Add new databases or remove existing ones.
• Table designer: Create tables with columns, indexes, and constraints.
• Foreign key management: Set up relationships with referential integrity.
• View and sequence management: Create and manage database views and sequences.
• User and role management: Control database access and permissions.
• Data import/export: Transfer data in CSV, JSON, or SQL formats.

Access these features through the context menu (right-click) in the Database Explorer.

Execute SQL queries directly in your IDE with the integrated SQL Editor:

• Syntax Highlighting: Full SQL syntax support.
• Results Display: View query results in a tabular format with sorting and filtering.
• Export Options: Export results to CSV, JSON, or SQL formats.
• Query Statistics: View execution time and performance metrics.
• Error Highlighting: Detailed error messages for debugging.

1. From Schema View: Right-click any table and select "Query Table" for a pre-filled SELECT query.
2. From Command Palette: Use Ctrl+Shift+P and search for "Neon: Open SQL Editor".

The SQL Editor connects directly to your database connection, so you can query any database in your current branch without additional setup.

View and edit your table data with a spreadsheet-like interface:

• Paginated Display: Navigate through large datasets with page controls.
• Column Management: Show/hide columns, sort by any column.
• Data Types: Visual indicators for different data types (primary keys, foreign keys, etc.).
• Null Handling: Clear visualization of NULL values.

• Inline Editing: Edit field values directly in the table.
• Insert New Rows: Add new records with the "Add Row" button.
• Delete Rows: Remove records with confirmation dialogs.
• Real-time Validation: Data validation based on column types and constraints.

Row editing and deletion require tables to have a primary key defined. This ensures data integrity by uniquely identifying rows for safe updates.

1. From Schema View: Right-click any table and select "View Table Data".
2. The data opens in a new tab with full editing capabilities.
3. Changes are immediately applied to your database.
4. Use the refresh button to see updates from other sources.

Perfect for quick data inspection, testing, and small data modifications without writing SQL.

The Neon extension includes built-in support for AI-powered database features through the Neon MCP Server:

• Automatic MCP Server configuration: enables AI-powered database features with your coding agent.
• Chat with your database using natural language.
• AI-assisted SQL generation and schema understanding.
• View and manage MCP server status directly in the extension.

The MCP server is automatically configured when you sign in. You can view the status and manage the configuration from the extension panel.

This extension contributes the following settings:

You can run any command by opening the Command Palette (Cmd+Shift+P or Ctrl+Shift+P) and typing "Neon".

• Verify your Neon account is active.
• Ensure you have access to the selected project and branch.
• Check your network connection.

• Check the MCP Server panel status in the extension.
• Try disabling and re-enabling the MCP server.
• Reload the window after configuration changes.

• Use the refresh button in the Databases view title bar.
• Disconnect and reconnect to the branch.

• Branching in Neon.
• Neon MCP Server.
• Serverless driver.
• Discord Community.

Join our Discord Server to ask questions or see what others are doing with Neon. For paid plan support options, see Support.