Skip to main content
Glama
totonga

odsbox-jaquel-mcp

by totonga

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
ODSBOX_MCP_URLNoODS server URL for ods_connect_using_env.
ODSBOX_MCP_MODENoAuthentication mode for ods_connect_using_env: basic, m2m, or oidc.basic
ODSBOX_MCP_USERNoODS username (basic mode).
FASTMCP_LOG_LEVELNoControls the server-side log level (DEBUG, INFO, WARNING, ERROR, CRITICAL).INFO
ODSBOX_MCP_VERIFYNoTLS certificate verification (true/false).true
ODSBOX_MCP_PASSWORDNoODS password (basic mode; falls back to keyring).
ODSBOX_STATS_ENABLEDNoSet to '1', 'true', or 'yes' to enable tool and resource call monitoring.
ODSBOX_MCP_M2M_CLIENT_IDNoClient ID (m2m mode).
ODSBOX_MCP_OIDC_CLIENT_IDNoClient ID (oidc mode).
ODSBOX_MCP_M2M_CLIENT_SECRETNoClient secret (m2m mode; falls back to keyring).
ODSBOX_MCP_OIDC_REDIRECT_URINoRedirect URI (oidc mode, e.g. http://127.0.0.1:1234).
ODSBOX_MCP_M2M_TOKEN_ENDPOINTNoOAuth2 token endpoint (m2m mode).

Instructions

Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.

This server publishes no instructions, or was last inspected before Glama recorded them.

Capabilities

Features and capabilities supported by this server

Protocol revision2025-11-25

CapabilityDetails
tools
{
  "listChanged": true
}
logging
{}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}
extensions
{
  "io.modelcontextprotocol/ui": {}
}
experimental
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
query_validateA

Validate a Jaquel query structure for syntax errors and best practices.

query_get_operator_docsA

Get documentation and examples for a Jaquel operator.

query_get_patternB

Get a template for a common Jaquel query pattern.

query_list_patternsA

List all available Jaquel query patterns and templates.

query_generate_skeletonB

Generate a query skeleton for a specific entity and operation.

query_describeB

Describe what a Jaquel query does.

schema_get_entityA

Get available fields for an entity from ODS model.

schema_field_existsB

Check if a field exists in entity schema.

schema_list_entitiesA

Return a list of existing entities from the ODS server ModelCache.

schema_test_to_measurement_hierarchyA

Get hierarchical entity chain from AoTest to AoMeasurement via 'children' relation.

ods_connectB

Establish connection to ASAM ODS server for live model inspection.

ods_connect_using_envA

Establish connection to ASAM ODS server using environment variables.

Default prefix is ODSBOX_MCP; set ODSBOX_MCP_ENV_PREFIX or pass env_prefix. Falls back to legacy ODS_ prefix variables.

Supports three authentication modes via {prefix}MODE or ODSBOX_MCP{prefix}_MODE:

  • basic (default): Username/password. Vars: URL, USERNAME, PASSWORD, VERIFY.

  • m2m: OAuth2 client credentials. Vars: URL, M2M_TOKEN_ENDPOINT, M2M_CLIENT_ID, M2M_CLIENT_SECRET, M2M_SCOPE (optional, comma-separated), VERIFY.

  • oidc: OpenID Connect browser login. Vars: URL, OIDC_CLIENT_ID, OIDC_REDIRECT_URI, OIDC_CLIENT_SECRET (optional), OIDC_WEBFINGER_PATH_PREFIX, OIDC_AUTHORIZATION_ENDPOINT, OIDC_TOKEN_ENDPOINT, OIDC_LOGIN_TIMEOUT, OIDC_REDIRECT_INSECURE, OIDC_SCOPE, VERIFY.

Secrets (passwords, client_secrets) fall back to keyring when not in env.

ods_disconnectA

Close connection to ODS server.

ods_get_connection_infoA

Get current ODS connection information.

ods_connect_env_listA

List all ODS servers configured via environment variables.

Returns each server's prefix and URL so you can identify the right server and connect with ods_connect_using_env(env_prefix='PREFIX').

query_executeB

Execute a Jaquel query directly on connected ODS server.

data_get_quantitiesB

Get available measurement quantities for a submatrix.

data_read_submatrixA

Read timeseries data from a submatrix using bulk data access.

data_generate_fetcher_scriptB

Generate Python scripts for fetching submatrix data with error handling and data processing.

plot_comparison_notebookA

Generate a Jupyter notebook for comparing measurements.

Uses the active ODS connection (established via ods_connect or ods_connect_using_env). The generated notebook reads the password from the ODS_PASSWORD environment variable at runtime so no credentials are embedded in the notebook file.

plot_generate_codeA

Generate Python plotting code for measurement comparison.

help_bulk_apiA

Get help and guidance on using the Bulk API for loading timeseries data.

Use this to understand the 3-step workflow and common patterns.

Prompts

Interactive templates invoked by user choice

NameDescription
prompt_query_validateValidate a Jaquel Query. Learn how to validate a Jaquel query for syntax errors and best practices. Provides detailed feedback on query structure and suggestions for improvement.
explore_patternsExplore Jaquel Query Patterns. Discover common Jaquel query patterns and templates for tasks like: getting all instances, filtering by ID or name, case-insensitive search, time range queries, joins, and aggregations.
connect_ods_serverSet Up ODS Server Connection. Learn how to establish a connection to an ASAM ODS server for live model inspection, schema validation, and direct query execution.
timeseries_accessBulk Data Access & Submatrix Reading. Master the 3-step Bulk API workflow for efficient timeseries data access. Learn how to read submatrix data, generate fetcher scripts, and handle large datasets.

Resources

Contextual data attached and managed by the client

NameDescription
ODS Connection Setup GuideComplete guide for connecting to ASAM ODS servers and managing connections.
Common ODS WorkflowsStep-by-step workflows for typical ODS operations and data access patterns.
ODS Entity Hierarchy ReferenceUnderstanding ASAM ODS entity relationships (AoTest, AoMeasurement, etc.).
Query Execution PatternsBest practices and patterns for executing Jaquel queries against ODS servers.
Query Operators ReferenceComplete reference of all Jaquel query operators with examples and use cases.
Jaquel Syntax GuideComplete Jaquel query language syntax reference with examples and best practices.
ODS Connection TroubleshootingCommon connection issues and solutions for working with ASAM ODS servers.

TDQS

A3.8/5.0

Scored across 22 tools

Disambiguation4/5

Tools are largely distinct with clear domain prefixes (ods_, schema_, query_, data_, plot_), but there is minor overlap between plotting tools (plot_comparison_notebook vs plot_generate_code) and query pattern functions (query_get_pattern vs query_list_patterns), which could cause slight confusion.

Naming Consistency5/5

All tools follow a consistent snake_case naming convention with domain-based prefixes (e.g., ods_connect, schema_list_entities, query_validate, data_read_submatrix). This makes the set predictable and easy to navigate.

Tool Count4/5

At 22 tools, the set is above the typical 3-15 range but remains reasonable given the broad scope covering connection management, schema inspection, query building, data retrieval, and plotting. Each tool serves a distinct purpose, so it does not feel bloated.

Completeness5/5

The tool set comprehensively covers the advertised workflow: connection setup and teardown, schema exploration, query validation and generation, data access, and plotting. No obvious gaps exist for the stated purpose of working with ODS/ASAM data.

Maintenance

ActivityMaintained
ResponsivenessNo issues