Content
# Archery MCP Server
[](https://pypi.org/project/archery-mcp-server/)
[](LICENSE)
Wraps the [Archery](https://github.com/hhyo/Archery) SQL review and query platform's API as a [MCP](https://modelcontextprotocol.io/) tool, allowing AI Agents (Kiro/Claude/Cursor, etc.) to directly operate the Archery platform.
## Tool List
As an [Agent Skill](https://skills.sh/), install and automatically configure MCP:
```bash
npx skills add ckall/archery-mcp-server
```
After installation, fill in your Archery connection information in the MCP configuration to use.
## Manual Installation
### Method 1: uvx (no prerequisites, recommended)
```json
{
"mcpServers": {
"archery": {
"command": "uvx",
"args": ["archery-mcp-server@latest"],
"env": {
"ARCHERY_BASE_URL": "http://archery.example.com",
"ARCHERY_USERNAME": "admin",
"ARCHERY_PASSWORD": "your_password"
}
}
}
}
```
### Method 2: pip install
```bash
pip install archery-mcp-server
```
Then configure MCP:
```json
{
"mcpServers": {
"archery": {
"command": "archery-mcp",
"env": {
"ARCHERY_BASE_URL": "http://archery.example.com",
"ARCHERY_USERNAME": "admin",
"ARCHERY_PASSWORD": "your_password"
}
}
}
}
```
## Environment Variables
| Variable | Required | Description |
|----------|----------|-------------|
| `ARCHERY_BASE_URL` | ✅ | Archery platform URL |
| `ARCHERY_USERNAME` | ✅ | Login username |
| `ARCHERY_PASSWORD` | ✅ | Login password |
## Feature Coverage (26 tools)
| Module | Number of Tools | Capability |
|--------|---------------|------------|
| SQL Order Management | 6 | Submit/View/Review/Execute/Pending/Log |
| SQL Review | 1 | Syntax Check (goInception) |
| SQL Query | 6 | Execute Query/Browse Resources/Table Structure/History/Favorites |
| Instance Management | 6 | CRUD/Resource Browsing/Query by Table Name |
| User Management | 4 | CRUD |
| Resource Group/Permission Group | 4 | List/Create |
See detailed tool descriptions in [SKILL.md](./SKILL.md).
## Project Structure
```
archery-mcp-server/
├── SKILL.md # Agent Skill definition (install and use)
├── pyproject.toml # Python package configuration
├── mcp.json # MCP configuration example
└── src/archery_mcp/
├── __init__.py
├── client.py # Archery API client (JWT authentication)
└── server.py # MCP Server (26 tools)
```
## Development
```bash
# Clone
git clone https://github.com/ckall/archery-mcp-server.git
cd archery-mcp-server
# Install development dependencies
pip install -e .
# Run locally
export ARCHERY_BASE_URL=http://localhost:9123
export ARCHERY_USERNAME=admin
export ARCHERY_PASSWORD=admin
archery-mcp
```
## Compatibility
- Python 3.10+
- Archery 1.8+ (REST API required)
- Supports all MCP compatible AI IDEs: Kiro, Claude Code, Cursor, Windsurf, etc.
## License
MIT
