slims-mcp

MCP server that gives AI models direct access to a SLiMS (Senayan Library Management System) MySQL database. Works with any MCP-compatible client — Claude Code, Claude Desktop, Gemini CLI, GPT (via MCP bridge), and others.

Tested against SLiMS v9 Bulian. Other versions should work as long as they share the same database schema.

• search_books — search by title, author, or subject with pagination
• search_latest_books — recently added books
• search_popular_books — most borrowed books based on loan history
• check_book_availability — check if a book is available for borrowing
• get_total_books — total book count statistics
• get_popular_subjects — popular subjects/topics

go build -o slims-mcp ./cmd/slims-mcp

Set environment variables before running:

| Variable | Required | Default | Description | | ----------------- | -------- | ----------- | ------------------------------------ | | SLIMS_DB_HOST | No | localhost | MySQL host | | SLIMS_DB_PORT | No | 3306 | MySQL port | | SLIMS_DB_USER | Yes | - | MySQL username | | SLIMS_DB_PASS | Yes | - | MySQL password | | SLIMS_DB_NAME | No | slims | Database name | | SLIMS_LOG_LEVEL | No | info | Log level (debug, info, warn, error) |

Create a .env file in the project directory and point cwd to it:

{
	"mcpServers": {
		"slims": {
			"command": "/path/to/slims-mcp",
			"cwd": "/path/to/slims-mcp"
		}
	}
}

{
	"mcpServers": {
		"slims": {
			"command": "/path/to/slims-mcp",
			"env": {
				"SLIMS_DB_HOST": "localhost",
				"SLIMS_DB_USER": "your_user",
				"SLIMS_DB_PASS": "your_password",
				"SLIM