umentation Website](https://www.kaiwudb.com/kaiwudb_docs/#/oss_dev/deployment/overview.html). - Create a user with appropriate privileges on tables and databases. For details, see [Create Users](https://www.kaiwudb.com/kaiwudb_docs/#/oss_dev/deployment/bare-metal/user-config-bare-metal.html). ### Steps 1. Clone the repository. ```shell git clone https://gitee.com/kwdb/kwdb-mcp-server cd kwdb-mcp-server ``` 2. Install dependencies. ```shell make deps ``` 3. Build the application. ```shell make build ``` If you succeed, the application adopts the following structure. ```plain mcp-kwdb-server-go/ ├── bin/ │ └── kwdb-mcp-server # Binary executable file ├── cmd/ │ └── kwdb-mcp-server/ │ └── main.go # The main application ├── pkg/ │ ├── db/ │ │ └── db.go # Database operations │ ├── prompts/ │ │ ├── prompts.go # MCP Prompts │ │ └── docs/ # MCP Prompts files │ │ ├── ReadExamples.md # Read query examples │ │ ├── WriteExamples.md # Write query examples │ │ ├── DBDescription.md # Database descriptions │ │ ├── SyntaxGuide.md # SQL Syntax guide │ │ ├── ClusterManagementGuide.md # Cluster management guide │ │ ├── DataMigrationGuide.md # Data migration guide │ │ ├── InstallationGuide.md # Installation guide │ │ ├── PerformanceTuningGuide.md # Performance tunning │ │ ├── TroubleShootingGuide.md # Troubleshooting guide │ │ ├── BackupRestoreGuide.md # Backup and restore guide │ │ └── DBATemplate.md # DBA templates │ ├── resources/ │ │ └── resources.go # MCP Resources │ ├── server/ │ │ └── server.go # KWDB MCP Server configurations │ ├── tools/ │ │ └── tools.go # MCP Tools │ └── version/ │ └── version.go # Version information ├── Makefile # Commands for building and running the KWDB MCP Server └── README.md # README file ``` ### Start KWDB MCP Server The KWDB MCP Server supports the following two transport modes: - StdIO (Standard Input/Output) mode: the KWDB MCP Server uses the standard input/output for communication. This is the default mode. - SSE (Server-Sent Events) mode: the KWDB MCP Server uses HTTP POST for communication between the server and the client. #### StdIO Mode - Run the KWDB MCP Server with a PostgreSQL connection string: ```shell ./bin/kwdb-mcp-server "postgresql://:@:/?sslmode=disable" ``` - Run the KWDB MCP Server using the Makefile: ```shell CONNECTION_STRING="postgresql://:@:/?sslmode=disable" make run ``` Parameters: - `username`: the username used to connect to the KWDB database - `password`: the password for the username - `hostname`: the IP address of the KWDB database - `port`: the port of the KWDB database - `database_name`: the name of the KWDB database - `sslmode`: the SSL mode, available options are `disable`, `allow`, `prefer`, `require`, `verify-ca` and `verify-full`. For details about the SSL mode, see [SSL Mode Parameters](https://www.kaiwudb.com/kaiwudb_docs/#/oss_dev/development/connect-kaiwudb/java/connect-jdbc.html#%E8%BF%9E%E6%8E%A5%E5%8F%82%E6%95%B0). #### SSE Mode To access KWDB databases deployed on other servers, you can start the KWDB MCP Server in SSE mode. > **Note** > > You need to provide the database connection string as the last parameter. - Run the KWDB MCP Server with a PostgreSQL connection string: ```shell ./bin/kwdb-mcp-server -t sse -addr ":8080" -base-url "http://localhost:8080" "postgresql://:@:

KWDB

コメント