PostgreSQL

PostgreSQL

By jamesg31 GitHub

-

postgresql database
Overview

what is PostgreSQL?

PostgreSQL is a Model Context Protocol server that provides read-only access to PostgreSQL databases, enabling LLMs to inspect database schemas and execute read-only queries.

how to use PostgreSQL?

To use PostgreSQL, configure it with the Claude Desktop app or run it using Docker or NPX with the appropriate PostgreSQL connection string.

key features of PostgreSQL?

  • Execute read-only SQL queries against connected databases.
  • Provides schema information for each table in JSON format, including column names and data types.
  • Automatically discovers schema information from database metadata.

use cases of PostgreSQL?

  1. Inspecting database schemas for data analysis.
  2. Executing read-only queries for reporting purposes.
  3. Integrating with LLMs for enhanced data interaction.

FAQ from PostgreSQL?

  • Can I modify data using this server?

No, this server only allows read-only access to the database.

  • How do I connect to my PostgreSQL database?

You can connect using a PostgreSQL URL format, including username and password if necessary.

  • Is there a license for this project?

Yes, this project is licensed under the MIT License.

Overview

what is PostgreSQL?

PostgreSQL is a Model Context Protocol server that provides read-only access to PostgreSQL databases, enabling LLMs to inspect database schemas and execute read-only queries.

how to use PostgreSQL?

To use PostgreSQL, configure it with the Claude Desktop app or run it using Docker or NPX with the appropriate PostgreSQL connection string.

key features of PostgreSQL?

  • Execute read-only SQL queries against connected databases.
  • Provides schema information for each table in JSON format, including column names and data types.
  • Automatically discovers schema information from database metadata.

use cases of PostgreSQL?

  1. Inspecting database schemas for data analysis.
  2. Executing read-only queries for reporting purposes.
  3. Integrating with LLMs for enhanced data interaction.

FAQ from PostgreSQL?

  • Can I modify data using this server?

No, this server only allows read-only access to the database.

  • How do I connect to my PostgreSQL database?

You can connect using a PostgreSQL URL format, including username and password if necessary.

  • Is there a license for this project?

Yes, this project is licensed under the MIT License.

No tools information available.
Postgres
Postgres by guoling2008

-

postgres database
View Details
Sqlite
Sqlite by sqlite

Database interaction and business intelligence capabilities

sqlite database
View Details
mcp-db-server
mcp-db-server by iotassss

-

mcp-db-server database
View Details
mcp-lancedb-server
mcp-lancedb-server by richard-gyiko

-

mcp-lancedb-server database
View Details
db-mcp
db-mcp by goru00

Database Model Context Protocol (DB-MCP) Server

db-mcp database
View Details

mysql数据库连接,改 f4ww4z/mcp-mysql-server中的连接配置支持cherry studio

mcp-mysql-server database
View Details

Mirror of

mysql database
View Details