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

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.

「データベース」の他のコンテンツ

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

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

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

PostgreSQL