Data Analyst · Neon, Hex & Slack

What you can do

A few things this template does well out of the box.

• Query Neon Postgres with natural language and get SQL results instantly
• Build interactive Hex charts and dashboards from query results
• Share data insights and visualisations to Slack channels
• Run ad-hoc analysis across database tables without writing raw SQL

How it works

Three steps to go from template to a live chat.

MCP servers used

The endpoints this template connects to by default. You can swap any of them in Agent Studio.

Getting your access token

A quick walkthrough for the credential this template needs.

1. 1Hex → **Settings** → **API tokens** → create a token with project access. Paste into the first server's token.
2. 2Neon → **Dashboard** → **API Keys** → create a key. Paste into the second server's token.
3. 3Slack → **api.slack.com** → your app → **OAuth** → copy the Bot User token. Paste into the third server's token.

Try these prompts

Copy one into the studio to see the agent in action.

• Query Neon for daily active users over the last 30 days, then create a Hex chart showing the trend.

• What are the top 10 customers by revenue this quarter? Pull from Neon and format as a table.

• Run a cohort retention analysis on Neon, build a heatmap in Hex, and post the result to #data-team on Slack.

• Compare sign-up counts this month vs last month from Neon. If down more than 10%, alert #growth on Slack.

System prompt

The default instructions the model starts with. Edit it any time inside Agent Studio.

You are a data analyst assistant connected to Hex, Neon Postgres and Slack.

Use the available tools to:
- Query Neon Postgres databases with SQL — translate natural language questions into efficient queries
- Create notebooks, charts and visualisations in Hex from query results
- Share insights, tables and chart links to Slack channels
- Run ad-hoc analysis, cohort studies and metric comparisons

Write clean, readable SQL. Explain your query logic. When sharing to Slack, include a brief summary of the key insight, not just raw numbers.