Aerostack
Aerostack
electrical_services

Neon MCP Server — Hosted for Any AI Agent

MCP Server language Hosted language Public

Query and write to your Neon serverless PostgreSQL database — select, insert, update, delete, and run raw SQL from any AI agent.

aerostack @aerostack verified
• v0.1.0 • MIT • Updated Jun 28, 2026
add_circleAdd to Workspace
robot_2

Use with AI AssistantsMCP

Connect Claude, Cursor, or any MCP-compatible client — then call tools directly

① Add This MCP Server

Paste into your AI client config — then all its tools are available instantly.

.claude/mcp.json
{
  "mcpServers": {
    "neon": {
      "url": "https://mcp.aerostack.dev/s/aerostack/mcp-neon",
      "headers": {
        "Authorization": "Bearer YOUR_AEROSTACK_TOKEN"
      }
    }
  }
}

Replace YOUR_AEROSTACK_TOKEN with your API token from the dashboard.

② Call a Tool

Ask your AI assistant to call a specific tool, or send raw JSON-RPC:

+1 more

Natural Language Prompt

“Use the _ping tool to verify database connectivity by running select 1. used internally by aerostack to validate credentials”

Using a Workspace?

Add this MCP to your Workspace — your team shares one token, secrets are stored securely, and every AI agent in the workspace can call it without per-user setup.

add_circleAdd to Workspace

description Overview

mcp-neon — Neon PostgreSQL MCP Server

Query and write to your Neon serverless PostgreSQL database from any AI agent.

Neon is a serverless Postgres platform with branching, autoscaling, and a native HTTP SQL API. This MCP server gives your AI agents direct read/write access to your Neon database: selecting rows, inserting records, updating data, deleting rows, and running raw parameterized SQL — all through natural language.

Live endpoint: https://mcp.aerostack.dev/s/aerostack/mcp-neon

What You Can Do

  • Query any table with filters, ordering, and pagination
  • Insert one or multiple rows in a single call
  • Update rows matching any SQL condition
  • Delete rows safely (WHERE clause always required)
  • Run raw parameterized SQL for complex queries
  • Introspect your schema — list tables and their columns

Available Tools

Tool Description
list_tables List all tables with column names and types
select Query rows with optional WHERE, ORDER BY, LIMIT
insert Insert one or more rows, returns inserted records
update Update rows matching a WHERE condition
delete Delete rows matching a WHERE condition
run_sql Execute any parameterized SQL query

Configuration

Variable Required Description How to Get
DATABASE_URL Yes Neon PostgreSQL connection string console.neon.tech → Your Project → Connection Details → copy Connection string

Connection string format: postgresql://user:pass@ep-xxx.region.aws.neon.tech/dbname?sslmode=require

Quick Start

Add to Aerostack Workspace
  1. Go to aerostack.dev → Your Project → MCPs
  2. Search for "Neon" and click Add to Workspace
  3. Add DATABASE_URL under Project → Secrets

Once added, every AI agent in your workspace can query your Neon database automatically.

Example Prompts
"List all tables in my database and describe their columns"
"Select the last 10 customers who signed up, ordered by created_at"
"Insert a new support ticket for customer_id 42 with subject 'Login issue'"
"Update the status to closed for all tickets older than 30 days"
"How many active users do I have?"
Direct API Call
curl -X POST https://mcp.aerostack.dev/s/aerostack/mcp-neon \
  -H 'Content-Type: application/json' \
  -H 'X-Mcp-Secret-DATABASE-URL: postgresql://user:pass@ep-xxx.neon.tech/dbname' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"list_tables","arguments":{}}}'

Security Notes

  • DATABASE_URL is injected at the Aerostack gateway layer — never stored in this worker's code
  • update and delete tools always require a where clause — full-table mutations are blocked
  • run_sql supports parameterized queries ($1, $2, ...) — use params array to prevent SQL injection

License

MIT

terminal Tools (7)

Available tools on this MCP server. Each tool can be called directly from any AI agent.

terminal
_ping #1

Verify database connectivity by running SELECT 1. Used internally by Aerostack to validate credentials.

terminal
list_tables #2

List all user tables in the Neon PostgreSQL database with their column names and types

terminal
select #3

Query rows from a table with optional WHERE filter, ORDER BY, and LIMIT

terminal
insert #4

Insert one or more rows into a table

terminal
update #5

Update rows in a table matching a WHERE condition

terminal
delete #6

Delete rows from a table matching a WHERE condition

terminal
run_sql #7

Execute a raw parameterized SQL query. Use $1, $2, ... for parameters.

Details

upgrade Version 0.1.0
gavel License MIT
wifi Transport streamable-http
lock Access Public
category Category Database
terminal Tools 7

language Live Endpoint

https://mcp.aerostack.dev/s/aerostack/mcp-neon

Sub-50ms globally · Zero cold start

Publisher

aerostack
@aerostack verified

Pre-built functions for the most common MCP tool patterns. Clone, extend, and deploy.

Tags

database postgres postgresql neon sql serverless
Browse more servers
electrical_services Browse all MCP servers grid_view Explore marketplace category Database MCP servers

Frequently asked questions

What is the Neon MCP server and what can it do? +

The Neon MCP server is hosted on Aerostack and exposes these tools to your AI agent: `_ping`, `list_tables`, `select`, `insert`, `update`. You get one hosted URL — no self-hosting — that works from Claude, Cursor, ChatGPT, Gemini, VS Code, or any MCP-compatible client, and you can share it with your team or combine it with other MCP servers in a workspace.

Is the Neon MCP server hosted, or do I have to run it myself? +

It's hosted on Aerostack's edge infrastructure — you don't deploy or maintain anything. Add it to a workspace and you get one authenticated URL, with secrets encrypted, that any AI agent or editor can connect to. Use it solo or share the same URL across your whole team.

Which AI agents and editors can use the Neon MCP server? +

Any MCP client: Claude and Claude Code, Cursor, ChatGPT, Gemini, Windsurf, Cline, VS Code, and custom agents. Because it's one hosted URL, the same Neon MCP server works everywhere — and you can compose it with other MCP servers, skills, and functions behind a single workspace URL.

How do I install the Neon MCP server in Claude Desktop? +

Add the following to your Claude Desktop config (`claude_desktop_config.json`): ```json { "mcpServers": { "@aerostack/mcp-neon": { "command": "npx", "args": ["-y", "@aerostack/@aerostack/mcp-neon"] } } } ``` Then restart Claude Desktop and the tools will appear automatically.

How do I use the Neon MCP server in Cursor? +

In Cursor, open **Settings → MCP** and add: ```json { "name": "@aerostack/mcp-neon", "command": "npx", "args": ["-y", "@aerostack/@aerostack/mcp-neon"] } ``` Save and reload Cursor. The MCP tools will be available in Agent mode.

Does Neon MCP require authentication? +

Yes. Neon requires authentication. Check the MCP's documentation for the required credentials.