Advertise
MCP.so
Sign In

PostgreSQL MCP Server with LLM Chat Example on Clever Cloud

@CleverCloud

Repository

Basic information

Category

Databases

License

MIT license

Transports

stdio

Author

CleverCloud

About PostgreSQL MCP Server with LLM Chat Example on Clever Cloud

A Node.js application on Clever Cloud that uses an MCP server for PostgreSQL along with a language model to enable natural language querying of a PostgreSQL database

PostgreSQL MCP Server with LLM Chat Example on Clever Cloud config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mcp-pg-example": {
      "command": "node",
      "args": [
        "scripts/initializeDb.js"
      ]
    }
  }
}

PostgreSQL MCP Server with LLM Chat Example on Clever Cloud tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is PostgreSQL MCP Server with LLM Chat Example on Clever Cloud?

This repository demonstrates how to deploy a Node.js application on Clever Cloud that uses the Model Context Protocol (MCP) server for PostgreSQL along with a language model to enable natural language querying of a PostgreSQL database. It is intended for developers who want to combine MCP, LLMs, and PostgreSQL in a cloud‑deployed chat interface.

How to use PostgreSQL MCP Server with LLM Chat Example on Clever Cloud?

Clone the repo, run npm install, copy .env.example to .env, fill in your PostgreSQL connection URI, LLM API key, and optional model/URL settings. Initialize the database with node scripts/initializeDb.js. Test the integration with node scripts/testMCP.js. Start the development server with npm run dev. Deploy to Clever Cloud using the CLI (clever create, clever addon create, clever deploy) or via the Clever Cloud Console.

Key features of PostgreSQL MCP Server with LLM Chat Example on Clever Cloud

  • Natural language querying of PostgreSQL databases
  • MCP server integration with the official PostgreSQL implementation
  • LangChain.js for LLM interactions
  • Simple web‑based chat interface
  • Express.js backend with API endpoints
  • Sample RAGmonsters dataset for testing

Use cases of PostgreSQL MCP Server with LLM Chat Example on Clever Cloud

  • Allow non‑technical users to query a database using plain English
  • Prototype and test MCP + LLM workflows on a cloud platform
  • Learn how to deploy a Node.js + PostgreSQL + MCP application on Clever Cloud
  • Explore a structured database schema via a conversational interface

Frequently asked questions

1

What are the prerequisites to run this application?

A Clever Cloud account, Clever Tools CLI installed, Node.js 23 or later, a PostgreSQL database, and access to an LLM API (e.g., OpenAI).

2

How do I deploy this application to Clever Cloud?

Use the CLI commands `clever create --type node <APP_NAME>`, `clever addon create <APP_NAME>-pg --plan dev`, then set required environment variables (`LLM_API_KEY`, etc.) and run `clever deploy`. You can also deploy from the Clever Cloud Console via Git or GitHub.

3

Which environment variables are required and which are optional?

Required: `POSTGRESQL_ADDON_URI` (auto‑set by Clever Cloud when linking a PostgreSQL add‑on) and `LLM_API_KEY`. Optional: `PORT` (default 8080), `LLM_API_MODEL` (default `gpt-4o-mini`), `LLM_API_URL` (default OpenAI’s base URL).

4

What should I do if the application doesn’t work?

Check the logs with `clever logs`, verify all environment variables are correctly set with `clever env`, and ensure the application is running with `clever status`.

5

Does the application work locally without Clever Cloud?

Yes. Set up a local PostgreSQL database, configure the `.env` file with your local connection URI, and run the development server or test script.

Comments

More Databases MCP servers

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

Advertise