Data Oil
Server Details
Data Oil is a multi-model database built for object storage. It uses a log-structured storage engine, snapshot isolation with optimistic commit, and a change feed from the write-ahead log. Its SQL dialect supports joins, window functions, CTEs, set operations, graph traversal and pattern matching. It has its own HNSW vector index and BM25 full-text index, and a write is searchable by keyword and vector as soon as it commits. Access is over HTTP, the PostgreSQL wire protocol (extended protocol). We have a founder's program available for projects which may be of interest https://dataoil.tech/founders.html if your interested lets chat ;)
- Status
- Healthy
- Uptime
- 100.0% over the last 24 hours
- Last Tested
- Transport
- Streamable HTTP · MCP 2025-11-25
- URL
- ChatGPT
- –
- Claude
- –
TDQS
Scored across 3 tools
The three tools target distinct layers: schema describes structure, query executes SQL, and ask answers natural-language questions via a model endpoint. ask and query both retrieve data, so an agent might occasionally hesitate between them, but the descriptions clearly differentiate SQL execution from model-based answering.
All names are simple single lowercase tokens, which is readable and consistent in style, but they mix verbs (ask, query) with a noun (schema) rather than following a predictable verb_noun pattern. The set is small enough that this is not confusing, but it is not a strong convention.
Three tools is a well-scoped surface for a read-only database assistant: describe the schema, run a query, or ask a natural-language question. Each tool earns its place and there is no redundant or filler tool.
For a deliberately read-only host, the surface covers introspection (schema), SQL retrieval (query), and natural-language retrieval (ask). Write operations are intentionally absent, and minor extras like query planning or collection listing are not necessary but would be nice.
Publisher details
- Operator
- Data Oil · Publisher source
- Operator website
- https://dataoil.tech · Publisher source
- Vendor relationship
- Not available
- Documentation
- Not available
- Privacy policy
- Not provided
- Trust center
- Unknown
- Restrictions
- There are no restrictions on the subscriber release, the sandbox details are available at https://sandbox.dataoil.tech/ We are currently looking 50 Founder for full details https://dataoil.tech/founders.html
Available Tools
3 toolsaskAInspect
Answer a question from the data, with the evidence used. Give either a statement that selects the rows to reason over, or a collection to search by keyword; the rows go to the tenant's own model endpoint and the answer names how many rows and bytes were sent. Inside the deployment, with an assistant configured, the orchestrator retrieves and cites instead, and prepare:true returns what would be sent without sending it.
Inputs: question (required), k, sql, params, +3 more.
queryAInspect
Run one read-only Data Oil SQL SELECT statement against the database and return its rows. This host is read-only: only SELECT is accepted (SEARCH_INDEX for keyword search, vector.neighbors for meaning). Rows are capped to keep the answer inside the context; ask for a LIMIT or a narrower WHERE when the answer says more remained.
Inputs: sql (required), limit, params.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
Related MCP Connectors
Search and SQL on object storage: full-text, vector and hybrid search plus SQL over your data.
A collaborative substrate over your data: vector, knowledge graph, SQL, geospatial, streaming.
Store, query, and update structured data from any AI agent
The grounded data layer for any LLM: governed SQL, metrics, lineage and catalog over your data.
Related MCP Servers
- FlicenseAqualityNot gradedmaintenanceEnables unified access to both structured databases (PostgreSQL, MySQL, SQLite, etc.) and unstructured object storage (AWS S3, Alibaba OSS, Huawei OBS, etc.) through a single interface.7-
- AlicenseBqualityNot gradedmaintenanceZero-config graph DB for builders, AI agents, and SaaS teams who move fast29885 npm1Apache 2.0
- AlicenseAqualityCmaintenanceQuery SQL databases (SQLite, PostgreSQL, BigQuery, Databricks) in natural language through a business semantic layer — glossary, metrics, and a data dictionary grounded against your real schema. Read-only by default, with an embedded SQLite + sqlite-vec metadata store and no external infra required.253MIT
- AlicenseNot gradedqualityDmaintenanceA comprehensive Data Platform server that enables seamless integration between PostgreSQL databases and MinIO object storage, with AI-powered natural language query capabilities.MIT
Glama MCP Gateway
Add one secure layer between your agents and this server.