Skip to main content
Glama
r3-yamauchi

Kintone MCP Server

by r3-yamauchi

search_records

Search records in Kintone apps using query syntax to filter, sort, and retrieve specific data based on field conditions and criteria.

Instructions

kintoneアプリのレコードを検索します。事前に対象アプリのフィールド一覧を把握するため、`get_form_fields` ツールで利用予定のフィールドコードやフィールドタイプを確認してからクエリーを作成することを推奨します。

【よく使用されるクエリ例】 • 文字列検索: Customer = "サイボウズ株式会社" (完全一致) • 部分一致: Customer like "株式会社" (部分一致) • ドロップダウン: Status in ("対応中","未対応") (複数値の選択) • 日付範囲: LimitDay >= "2022-09-29" and LimitDay <= "2022-10-29" • 日付関数: LimitDay < TODAY() (今日より前) • 複数条件: Status in ("対応中") and LimitDay < TODAY() • ソート: Status = "対応中" order by 更新日時 desc • ページング: Status = "対応中" order by $id desc limit 20 offset 20 • 空欄チェック: Detail is empty (文字列複数行の空欄) • 非空欄チェック: Detail is not empty (文字列複数行の非空欄) • 添付ファイル有無: Attachments is empty / is not empty • ユーザー検索: 作成者 in (LOGINUSER()) (自分が作成したレコード)

注意: is empty / is not empty は「文字列(複数行)」と「添付ファイル(FILE)」に対してのみ使用でき、「文字列(1行)」などの他のフィールドタイプに対しては使用できません。 クエリ式の詳細仕様や構文とすべての演算子や関数、フィールド別の使用可否といったkintoneの仕様については get_query_language_documentation ツールを実行して確認してください。

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
app_idYeskintoneアプリのID
queryNokintoneクエリ構文での検索条件。 基本形式: "フィールドコード 演算子 値" 例: • Status = "完了" (完全一致) • Customer like "株式会社" (部分一致) • Status in ("対応中","未対応") (複数選択) • LimitDay >= "2022-09-29" and LimitDay <= "2022-10-29" (範囲指定) • Detail is empty (文字列複数行の空欄チェック) • Detail is not empty (文字列複数行の非空欄チェック) • Attachments is empty / is not empty (添付ファイルの有無) • Status not in ("完了") order by 更新日時 desc limit 10 (ソート付き) 注意: is empty / is not empty は「文字列(1行)」では使用できません(文字列(複数行)と添付ファイル(FILE)は可)。 不明点は get_query_language_documentation ツールで仕様を確認してください。 オプション順序: order by → limit → offset 詳細はget_query_language_documentationを参照
fieldsNo取得するフィールド名の配列(省略時は全フィールド取得)
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It effectively describes key behaviors: it explains query syntax with examples, notes constraints (e.g., is empty/is not empty only works for specific field types), and mentions pagination and sorting options. However, it lacks details on error handling, rate limits, or authentication needs, which are common for such tools.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-structured with clear sections: purpose, recommendation, query examples, and notes. It is appropriately sized for a complex tool, though some examples could be condensed. Every sentence adds value, such as clarifying field type constraints and referencing other tools for details.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the complexity (search tool with query language), no annotations, and no output schema, the description is quite complete. It covers purpose, usage guidelines, behavioral aspects (query syntax, constraints), and parameter context. However, it lacks details on output format (e.g., structure of returned records) and error cases, which would be helpful for full completeness.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents all parameters (app_id, query, fields). The description adds value by providing extensive query examples and usage notes that clarify the semantics of the query parameter beyond the schema's basic examples, but it doesn't add significant meaning for app_id or fields parameters. Baseline 3 is appropriate as the schema does heavy lifting.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose: 'kintoneアプリのレコードを検索します' (searches records in a kintone app). It specifies the verb (search) and resource (records in a kintone app), and distinguishes itself from siblings like get_record (which retrieves a single record) or get_records (not listed, but implied as different).

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides explicit guidance on when to use this tool: it recommends using get_form_fields first to understand field codes and types before creating queries, and directs users to get_query_language_documentation for detailed syntax and specifications. It also distinguishes from siblings by not overlapping with tools like get_record or create_record.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/r3-yamauchi/kintone-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server