created by
vignesh-codesa month ago
vignesh-codesa month agoThis repo is an extension of PostgreSQL MCP Server providing functionalities to create tables, insert entries, update entries, delete entries, and drop tables.
Information
What is PostgreSQL MCP Server?
PostgreSQL MCP Server is an extension that allows Large Language Models (LLMs) to interact with PostgreSQL databases, enabling CRUD (Create, Read, Update, Delete) operations on database entries.
How to use PostgreSQL MCP Server?
To use the server, install Docker, clone the repository, run the PostgreSQL Docker container, and connect it with the Claude Desktop app by updating the configuration file.
Key features of PostgreSQL MCP Server?
- Create, insert, update, delete, and drop tables dynamically.
- Execute read-only SQL queries against the connected database.
- Provides schema information for each table in JSON format.
Use cases of PostgreSQL MCP Server?
- Creating and managing database schemas dynamically.
- Performing complex queries and data manipulations through LLMs.
- Integrating with applications that require database interactions.
FAQ from PostgreSQL MCP Server?
- Can I use this server with any PostgreSQL database?
Yes! It is designed to work with any PostgreSQL database.
- Is there a limit to the number of tables I can create?
No, you can create as many tables as your database can handle.
- What happens if I delete a table?
The table and all its data will be permanently removed from the database.
Recommended Servers
GithubMCP Server for the GitHub API, enabling file operations, repository management, search functionality, and more.
Mcp Server RagdocsAn MCP server that provides tools for retrieving and processing documentation through vector search, both locally or hosted. Enabling AI assistants to augment their responses with relevant documentation context.
MongoDB LensFull featured MCP Server for MongoDB database analysis.
Mcp TimeplusMCP timeplus for Apache Kafka, ClickHouse and Timeplus. Able to list Kafka topics, poll Kafka messages, save Kafka data locally and query with SQL via Timeplus
Template for MCP Server
ChatSumQuery and Summarize your chat messages.
Mcp Databricks ServerThis is a Model Context Protocol (MCP) server for executing SQL queries against Databricks using the Statement Execution API.
It enables AI assistants to directly query Databricks data warehouses, analyze database schemas, and retrieve query results in a structured format, all while respecting proper permission boundaries.
It can retrieve data by performing SQL requests using the Databricks API.
When used in an Agent mode, it can successfully iterate over a number of requests to perform complex tasks.
It is even better when coupled with Unity Catalog Metadata.
Microsoft SQL Server MCP Server (MSSQL)MS SQL MCP Server
An easy-to-use bridge that lets AI assistants like Claude directly query and explore Microsoft SQL Server databases. No coding experience required!
What Does This Tool Do?
This tool allows AI assistants to:
Discover tables in your SQL Server database
View table structures (columns, data types, etc.)
Execute read-only SQL queries safely
Generate SQL queries from natural language requests
Perplexity Web Search MCP ServerA perplexity MCP server
Nuanced MCP ServerA Model Context Protocol (MCP) server that provides call graph analysis capabilities to LLMs through the nuanced library