# dataoil.tech

> dataoil.tech is an MCP server for databases. MCP server to query Data Oil databases with SQL, schema discovery and search. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Platforms:** API
- **Repository:** https://github.com/data-oil/sandbox
- **MCP Registry name:** tech.dataoil/mcp
- **Categories:** [databases](https://ai-powered.com/categories/databases), [mcp data access](https://ai-powered.com/categories/mcp-data-access)
- **Listing updated:** 2026-11-21

## About

Connects AI clients over stdio to Data Oil databases, so a model can read schemas, run SQL, search records and ingest data without leaving its chat or coding session. The registry entry lists SQL, schema discovery, search and ingestion as its three areas.

The README describes a public read-only sandbox that the sample projects sign into by default. Writes there are refused with a 403, while full keyword search is available. Using your own tenant needs an API key or an account name and password, and the README says creating databases requires a tenant administrator or Database Managers role.

The package is aimed at developers and data teams who already use Data Oil, or are evaluating it, and want an AI assistant to work against their databases. The README says the public clients are new, the source is closed, and semantic vector search is disabled in the free sandbox.

## Features

- **SQL querying:** Runs SQL queries against Data Oil collections from an MCP-compatible AI client.
- **Schema discovery:** Lists databases and reads collection schemas so the assistant can plan its queries.
- **Keyword search:** Searches stored text by keyword, including across the sandbox's five-language passages.
- **Data ingestion:** Writes records into a tenant database when the credential allows it.
- **Read-only public sandbox:** Lets you try the server against a public sample database with a read-only account.
- **Stdio transport:** Runs as a local process over stdio, installed from npm as @dataoil/mcp.

## Good for

- Asking an AI assistant questions about a Data Oil database in plain language
- Exploring an unfamiliar collection's schema before writing queries
- Running keyword searches across stored documents from a coding assistant
- Testing an MCP integration against the read-only public sandbox before using a tenant

## Install

### Claude Code (Terminal)

```sh
claude mcp add mcp -- npx -y @dataoil/mcp
```

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@dataoil/mcp"
      ]
    }
  }
}
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@dataoil/mcp"
      ]
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@dataoil/mcp"
      ]
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@dataoil/mcp"
      ]
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@dataoil/mcp"
      ]
    }
  }
}
```

## FAQ

### How is the server installed?

The registry entry names the npm package @dataoil/mcp at version 0.1.9, which runs over stdio. The README gives the command npm install @dataoil/mcp@0.1.9.

### Can the public sandbox be written to?

No. The README says every write to the public sandbox is refused with 403 Security.

### What credentials does a tenant need?

The README says an API key, minted in the console or with POST /api/v2/tokens, or an account name and password is needed for your own tenant.

### Is the source code open?

The README says the public clients are new and their source is closed. The package is covered by the Data Oil Software Licence.

### How do I add dataoil.tech to Claude Code?

Run this command in your terminal: claude mcp add mcp -- npx -y @dataoil/mcp

### What are the best alternatives to dataoil.tech?

The closest alternatives to dataoil.tech are SQL Server MCP (Windows), MCP Database Server, stoolap, Mongodb MCP Server and SynapCores.

## Where this comes from

- Description: written from the project's README and its MCP Registry entry.
- Install steps: from the official MCP Registry entry.

## Alternatives

- [SQL Server MCP (Windows)](https://ai-powered.com/mcp/sql-server-mcp-windows): SQL Server MCP (Windows) is an open-source MCP server for databases.
- [MCP Database Server](https://ai-powered.com/mcp/mcp-database-server): MCP Database Server is an open-source MCP server for databases.
- [stoolap](https://ai-powered.com/mcp/stoolap): stoolap is an open-source MCP server for databases.
- [Mongodb MCP Server](https://ai-powered.com/mcp/mongodb-mcp-server): Mongodb MCP Server is an open-source MCP server for databases.
- [SynapCores](https://ai-powered.com/mcp/synapcores): SynapCores is a free MCP server for databases.
- [SQL Server MCP (macOS)](https://ai-powered.com/mcp/sql-server-mcp-macos): SQL Server MCP (macOS) is an open-source MCP server for databases.
- [MCP Hydrolix](https://ai-powered.com/mcp/mcp-hydrolix): MCP Hydrolix is an open-source MCP server for databases.
- [MultiDB MCP](https://ai-powered.com/mcp/multidb-mcp): MultiDB MCP is an open-source MCP server for databases.

---
Source: https://ai-powered.com/mcp/dataoil-tech
