OB

openbudget/budgetkey-mcp

数据库管理

本页由 AI 翻译,技术细节请以原文为准。 查看原文

12 stars 13 forks 质量 69 趋势 23

A fastmcp server for open budget project

概览

An MCP (Model Context Protocol) server that provides access to the Israeli State Budget (BudgetKey) API through Claude and other AI assistants. The BudgetKey MCP Server enables AI assistants to query and analyze Israeli budget data, including: - (ספר התקציב) - Planned and executed state budget - - Budgetary support programs provided by the state - - Individual payments under support programs - - Government contracts with suppliers - - Information on organizations, companies, associations - - Data on taxes, fees, and revenues - - Requests to modify the budget Get comprehensive information about any dataset, including its columns and database schema. Always use this tool before querying a dataset. - dataset: Dataset ID (e.g., budget_items_data, contracts_data) Perform free-text search on a dataset to find relevant items. Use this to locate textual identifiers before performing database queries.

README

以下为原文 README 节选,完整内容请查看原文。

BudgetKey MCP Server

An MCP (Model Context Protocol) server that provides access to the Israeli State Budget (BudgetKey) API through Claude and other AI assistants.

Overview

The BudgetKey MCP Server enables AI assistants to query and analyze Israeli budget data, including:

  • Budget Book Data (ספר התקציב) - Planned and executed state budget
  • Support Programs - Budgetary support programs provided by the state
  • Support Transactions - Individual payments under support programs
  • Procurement Contracts - Government contracts with suppliers
  • Entities - Information on organizations, companies, associations
  • State Revenues - Data on taxes, fees, and revenues
  • Budget Change Requests - Requests to modify the budget

Data is available from 1997 to 2025.

Features

The server provides three main tools:

DatasetInfo

Get comprehensive information about any dataset, including its columns and database schema. Always use this tool before querying a dataset.

Parameters:

  • dataset: Dataset ID (e.g., budget_items_data, contracts_data)

DatasetFullTextSearch

Perform free-text search on a dataset to find relevant items. Use this to locate textual identifiers before performing database queries.

Parameters:

  • dataset: Dataset ID
  • q: Search query text

DatasetDBQuery

Execute SQL queries on a dataset’s database to retrieve precise information. Always include the item_url field to provide direct links to the data.

Parameters:

  • dataset: Dataset ID
  • query: PostgreSQL-compatible SQL query
  • page_size: Number of rows to return (default: 50)

Available Datasets

Dataset ID Description
budget_items_data Budget book data - planned and executed expense budget
support_programs_data Budgetary support programs
supports_transactions_data Individual support payments to organizations
contracts_data Government procurement contracts
entities_data Corporations, companies, associations, local authorities
income_items_data State revenues - taxes, fees, expected revenues
budgetary_change_requests_data Budget change requests
budgetary_change_transactions_data Budget change transactions

Installation

📖 For detailed integration instructions with Claude Desktop, VS Code, Cursor, and other clients, see the Integration Guide

Quick Start: Claude Desktop

Add to your Claude Desktop configuration file:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json Windows: %APPDATA%\Claude\claude_desktop_config.json

{
  "mcpServers": {
    "budgetkey": {
      "type": "http",
      "url": "https://next.obudget.org/mcp"
    }
  }
}

Restart Claude Desktop and you’re ready to query Israeli budget data!

Using Docker

docker run -p 8000:8000 ghcr.io/openbudget/budgetkey-mcp:latest
在 GitHub 查看完整 README

安装

docker run -p 8000:8000 ghcr.io/openbudget/budgetkey-mcp:latest
新手?先看 mcpskill.org 教程 →

配置

{ "mcpServers": { "budgetkey": { "type": "http", "url": "https://next.obudget.org/mcp" } } }