MCP_PostgreSQL is a .NET solution that provides integration between Model Context Protocol (MCP) and PostgreSQL databases. It consists of two main components:
- PostgreSqlAPI: An ASP.NET Core Web API that provides RESTful interfaces for interacting with PostgreSQL databases.
- ConsoleMcpPostgreSQL: A command-line application that uses the Model Context Protocol to interact with PostgreSQL.
- PostgreSQL database schema exploration
- Query execution against PostgreSQL databases
- Integration with Model Context Protocol
- RESTful API for database operations
- Cross-origin resource sharing (CORS) support
- Interactive Swagger documentation
- .NET 8.0
- ASP.NET Core
- Npgsql (PostgreSQL .NET driver)
- Model Context Protocol (MCP)
- Swagger/OpenAPI
- .NET 8.0 SDK or later
- PostgreSQL database server
- Visual Studio 2022 or any compatible IDE
- Clone the repository:
git clone https://github.com/yourusername/MCP_PostgreSQL.git
cd MCP_PostgreSQL- Build the solution:
dotnet buildConfigure your PostgreSQL connection string in the appropriate configuration files:
- For PostgreSqlAPI:
appsettings.json - For ConsoleMcpPostgreSQL: Update the connection settings in the appropriate configuration
cd PostgreSqlAPI
dotnet runThe API will be available at:
- HTTP: http://localhost:5000
- HTTPS: https://localhost:5001
- Swagger UI: https://localhost:5001/swagger
cd ConsoleMcpPostgreSQL
dotnet runThe PostgreSqlAPI provides the following endpoints:
- GET /api/mcp/schema: Retrieve database schema information
- POST /api/mcp/query: Execute SQL queries against the PostgreSQL database
Detailed API documentation is available through Swagger when running the application.
-
PostgreSqlAPI
- Controllers: Contains API controllers
- Models: Data models for API requests and responses
- Services: Database interaction services
-
ConsoleMcpPostgreSQL
- Uses Model Context Protocol for PostgreSQL interaction
- Provides command-line interface for database operations
[Specify your license information]
[Your contact information]