PostgreSQL MCP Server with LLM Chat Example on Clever Cloud

@CleverCloud

代码仓库

基本信息

分类

数据库

许可证

MIT license

传输方式

stdio

作者

CleverCloud

关于 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 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

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

PostgreSQL MCP Server with LLM Chat Example on Clever Cloud 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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

常见问题

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).

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.

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).

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`.