ralfbecher avatar

Orionbelt Analytics

ralfbecher/orionbelt-analytics

Builds RDF/OWL ontologies from relational database schemas across eight connectors including PostgreSQL, Snowflake, BigQuery, and DuckDB. The ontology includes SQL annotations that map OWL classes and properties back to actual tables, columns, and foreign keys. Exposes GraphRAG for semantic schema discovery, a SPARQL 1.1 query interface via Oxigraph, and deterministic OBQC validation that catches table/column mismatches, invalid joins, type errors, and fan traps before SQL hits the database. Also generates Plotly charts with MCP UI rendering. Reach for this when you need Text to SQL with structural guarantees, or when you want semantic layer tooling that understands relationships and prevents Cartesian products through ontology aware validation rather than hoping the LLM gets it right.

GitHub stars
32
tools
28
transport
STDIO
last updated
Feb 19, 2026

Tools

28 tools

Public tool metadata for what this MCP can expose to an agent.

connect_databaseConnect to any supported database using .env credentials

Connect to any supported database using .env credentials

No parameter schema in public metadata yet.

list_databasesList the databases configured on the server, by name and description

List the databases configured on the server, by name and description

No parameter schema in public metadata yet.

list_schemasList available schemas in the connected database

List available schemas in the connected database

No parameter schema in public metadata yet.

reset_cacheClear cached schema and ontology data for the current session

Clear cached schema and ontology data for the current session

No parameter schema in public metadata yet.

discover_schemaAnalyze schema structure with automatic GraphRAG + ontology generation

Analyze schema structure with automatic GraphRAG + ontology generation

No parameter schema in public metadata yet.

get_table_detailsGet detailed column, key, and constraint info for a specific table

Get detailed column, key, and constraint info for a specific table

No parameter schema in public metadata yet.

cleanup_workspaceDelete all workspace files for the current connection and start fresh

Delete all workspace files for the current connection and start fresh

No parameter schema in public metadata yet.

generate_ontologyGenerate RDF/OWL ontology from schema with SQL mapping annotations

Generate RDF/OWL ontology from schema with SQL mapping annotations

No parameter schema in public metadata yet.

suggest_semantic_namesDetect abbreviations and cryptic names for business-friendly renaming

Detect abbreviations and cryptic names for business-friendly renaming

No parameter schema in public metadata yet.

apply_semantic_namesApply LLM-suggested semantic names and descriptions to ontology

Apply LLM-suggested semantic names and descriptions to ontology

No parameter schema in public metadata yet.

load_my_ontologyLoad a custom .ttl ontology file from an import folder

Load a custom .ttl ontology file from an import folder

No parameter schema in public metadata yet.

validate_relationshipCheck a relationship against the data and record the verdict in the ontology

Check a relationship against the data and record the verdict in the ontology

No parameter schema in public metadata yet.

download_artifactDownload ontology or R2RML mapping as a Turtle file

Download ontology or R2RML mapping as a Turtle file

No parameter schema in public metadata yet.

sample_table_dataPreview table data with row limit and injection protection

Preview table data with row limit and injection protection

No parameter schema in public metadata yet.

execute_sql_queryExecute SQL with OBQC validation, security checks, and fan-trap detection

Execute SQL with OBQC validation, security checks, and fan-trap detection

No parameter schema in public metadata yet.

generate_chartGenerate Plotly charts (bar, line, scatter, heatmap) with MCP-UI rendering

Generate Plotly charts (bar, line, scatter, heatmap) with MCP-UI rendering

No parameter schema in public metadata yet.

graphrag_searchSemantic search + schema overview (auto-initialized by discover_schema)

Semantic search + schema overview (auto-initialized by discover_schema)

No parameter schema in public metadata yet.

graphrag_query_contextGet optimized context for SQL generation (85-95% token reduction)

Get optimized context for SQL generation (85-95% token reduction)

No parameter schema in public metadata yet.

graphrag_find_join_pathDiscover join paths between tables via graph traversal

Discover join paths between tables via graph traversal

No parameter schema in public metadata yet.

reachable_fromDimension-capable tables for an anchor grain (many-to-one closure)

Dimension-capable tables for an anchor grain (many-to-one closure)

No parameter schema in public metadata yet.

measurable_fromMeasure-capable tables for an anchor grain (one-to-many closure)

Measure-capable tables for an anchor grain (one-to-many closure)

No parameter schema in public metadata yet.

plan_composite_queryAdvise a fan-trap-safe Composite Fact Layer (UNION ALL) decomposition

Advise a fan-trap-safe Composite Fact Layer (UNION ALL) decomposition

No parameter schema in public metadata yet.

store_ontology_in_rdfPersist ontology in Oxigraph for SPARQL access

Persist ontology in Oxigraph for SPARQL access

No parameter schema in public metadata yet.

query_sparqlExecute SPARQL queries (SELECT, ASK, CONSTRUCT — auto-detected)

Execute SPARQL queries (SELECT, ASK, CONSTRUCT — auto-detected)

No parameter schema in public metadata yet.

add_rdf_knowledgeAdd custom metadata triples to the RDF store

Add custom metadata triples to the RDF store

No parameter schema in public metadata yet.

save_semantic_modelSave a semantic model (e.g., OBML YAML) to the workspace

Save a semantic model (e.g., OBML YAML) to the workspace

No parameter schema in public metadata yet.

get_semantic_modelRetrieve a stored semantic model by name

Retrieve a stored semantic model by name

No parameter schema in public metadata yet.

list_semantic_modelsList all stored semantic models for the current connection

List all stored semantic models for the current connection

No parameter schema in public metadata yet.

Sponsors

Readme

OrionBelt Logo

OrionBelt® Analytics

The Ontology-based MCP server for your Text-2-SQL convenience.

Version 2.3.0 Python 3.13+ License: BUSL-1.1 FastMCP 4.0.5+ RDF/OWL


View the full README on GitHub

Details

Repository
github.com/ralfbecher/orionbelt-analytics
Categories
Databases, Monitoring & Observability
Package
orionbelt-analytics
Transport
STDIO
Registry
MCP registry, active

Related Databases MCP servers

View all
1greptimeteam avatarGreptimedb Mcp Servergreptimeteam/greptimedb-mcp-serverQuery GreptimeDB metrics, logs and traces with SQL, TQL and RANGE. Manage pipelines and dashboards.29stars
2insforge avatarInsForgeinsforge/insforge-mcpMCP server for InsForge BaaS — database, storage, edge functions, and deployments29stars
3roomi-fields avatarRTFMroomi-fields/rtfmLocal retrieval for AI agents: index code, docs, PDFs, data in SQLite; 24 parsers, served via MCP.27stars
4isdaniel avatarPostgreSQL performance Tuner MCP Serverisdaniel/pgtuner_mcpprovides AI-powered PostgreSQL performance tuning capabilities.24stars
5sidd27 avatarInfrawisesidd27/infrawiseLive AWS, database & Kafka infrastructure context for AI coding assistants via MCP.22stars
6devopam avatarMcpgdevopam/mcpgProduction-grade PostgreSQL MCP server — 279 tools for query, tuning & ops, read-only by default.0stars