Can it modify database data?

It provides an execute tool for INSERT, UPDATE, and DELETE statements, unless the connection is configured as read-only.

What SQL safety controls are included?

The server uses prepared statements, allows one statement per query, blocks DROP, ALTER, and TRUNCATE, and supports query timeouts and response-size limits.

MCP Datalink

Q: Which MCP clients are supported?

The README lists Claude Desktop, Claude Code, Cursor, Cline, and any MCP-compatible client.

databasespostgresqlmysqlsqlitedeveloper-tools

Secure MCP database access for PostgreSQL, MySQL, and SQLite with schema inspection and constrained query execution.

Quick Install

Automated & IDE Setup

Copy the AI prompt to install this server into Claude Code, Cursor, or another agent — or use 1-click editor setup below.

Add to Cursor Add to VS Code

Not yet automatically verified

We haven't yet run this listing's install command through our automated sandbox check. This isn't a red flag — we're steadily working through the catalog.

Manual Client & Custom JSON ConfigExpand JSON ▾

Client Config & Setup

Choose your client or environment

Target File:~/Library/Application Support/Claude/claude_desktop_config.json

claude_desktop_config.json

{
  "mcpServers": {
    "pilat-mcp-datalink": {
      "command": "npx",
      "args": [
        "-y",
        "@pilat/mcp-datalink"
      ]
    }
  }
}

💡 Paste the JSON block into your client's configuration file under mcpServers, then restart the application.

Overview

This server connects MCP clients to configured PostgreSQL, MySQL, and SQLite databases. It supports schema inspection, read queries, data modification, and query plans, with prepared statements, single-statement queries, DDL blocking, timeouts, and response limits. Use it when an AI assistant needs controlled access to relational database data.

Use cases

Inspect database tables, schemas, indexes, and foreign keys

Run read-only SELECT queries against configured databases

Execute INSERT, UPDATE, and DELETE statements where writes are allowed

Review query execution plans

Separate database connections with per-connection read-only settings

Key features

PostgreSQL, MySQL, and SQLite connections

Table listings with row counts

Schema, index, and foreign-key inspection

Parameterized queries with single-statement enforcement

Per-connection read-only mode

Query timeouts and response-size limits

Capabilities & Tool Schemas (6)Self-reported

Inspect callable tools, capabilities, and parameters exposed to AI agents by MCP Datalink.

list_databases

List configured database connections

list_tables

List tables with row counts

describe_table

Get schema, indexes, foreign keys

query

Run SELECT queries

execute

Run INSERT/UPDATE/DELETE

explain

Show query execution plans

Documentation Overview

@pilat/mcp-datalink

MCP server for PostgreSQL, MySQL, and SQLite. Gives AI assistants secure database access via Model Context Protocol.

Terminal

npx @pilat/mcp-datalink

Works with Claude Desktop, Claude Code, Cursor, Cline, and any MCP-compatible client.

Installation

Add to your MCP client config file (see config locations below):

config.json

{
  "mcpServers": {
    "datalink": {
      "command": "npx",
      "args": ["-y", "@pilat/mcp-datalink"],
      "env": {
        "DATALINK_ANALYTICS_URL": "postgresql://user:password@localhost:5432/analytics",
        "DATALINK_ANALYTICS_READONLY": "true",

        "DATALINK_INVENTORY_URL": "mysql://user:password@localhost:3306/inventory",

        "DATALINK_CACHE_URL": "sqlite:///path/to/cache.db"
      }
    }
  }
}

This creates three database connections: analytics (read-only), inventory, and cache.

Variable	Description
`DATALINK_{NAME}_URL`	Connection URL (creates database named `{name}`)
`DATALINK_{NAME}_READONLY`	Set to `true` to block writes
`DATALINK_{NAME}_MAX_TIMEOUT`	Max query timeout in ms (caps model requests)

Connection URL formats:

bash

# PostgreSQL
postgresql://user:password@localhost:5432/dbname
postgresql://user:password@localhost:5432/dbname?sslmode=require

# MySQL
mysql://user:password@localhost:3306/dbname
mysql://user:password@localhost:3306/dbname?ssl=true

# SQLite
sqlite:///path/to/database.db
sqlite:///Users/me/data/app.sqlite
sqlite://../relative/path/data.db

Environment Variable Substitution

URLs support ${VAR} syntax to reference other environment variables:

config.json

{
  "mcpServers": {
    "datalink": {
      "command": "npx",
      "args": ["-y", "@pilat/mcp-datalink"],
      "env": {
        "DATALINK_MAIN_URL": "${DATABASE_URL}"
      }
    }
  }
}

This allows reusing existing environment variables (like DATABASE_URL from your shell or .env file).

Supported syntax:

Syntax	Description
`${VAR}`	Expands to value of `VAR`, or keeps `${VAR}` if unset
`${VAR:-default}`	Expands to value of `VAR`, or `default` if unset

Examples:

bash

# Reference existing DATABASE_URL
DATALINK_MAIN_URL="${DATABASE_URL}"

# Build URL from parts
DATALINK_MAIN_URL="postgresql://${DB_USER}:${DB_PASS}@${DB_HOST}:5432/mydb"

# With default values
DATALINK_MAIN_URL="postgresql://localhost:${DB_PORT:-5432}/mydb"

Config File Locations

Client	Config file
Claude Code	`~/.claude.json` (global) or `.mcp.json` (project)
Claude Desktop (macOS)	`~/Library/Application Support/Claude/claude_desktop_config.json`
Claude Desktop (Windows)	`%APPDATA%\Claude\claude_desktop_config.json`
Cursor	`~/.cursor/mcp.json` or Settings → Features → MCP Servers
Cline	`cline_mcp_settings.json` or VS Code settings `cline.mcpServers`

Tools

Tool	Description
`list_databases`	List configured database connections
`list_tables`	List tables with row counts
`describe_table`	Get schema, indexes, foreign keys
`query`	Run SELECT queries
`execute`	Run INSERT/UPDATE/DELETE
`explain`	Show query execution plans

Security

Prepared statements only (no SQL injection)
Single statement per query (no chaining)
DDL blocked (no DROP, ALTER, TRUNCATE)
Readonly mode per connection
Response size limit (100 rows, 64KB default, configurable via DATALINK_MAX_TOTAL_SIZE)
Query timeout: 30s default, model can request up to 10min, MAX_TIMEOUT caps it

License

MIT

Read the full README →View source on GitHub →

Related MCP Servers

View all in Databases View all alternatives

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

GitHub stars

Stargazers on the source repository.

npm downloads

230

Package downloads in the last 30 days.

Last commit

11d ago

Most recent push to the default branch.

Tools exposed

Callable tools this server registers over MCP.

Directory activity

1 views

Config copies, upvotes, and views on AllMCPs.

Reviews

No reviews yet — be the first to share how this listing worked for you.

Frequently Asked Questions about MCP Datalink

It supports PostgreSQL, MySQL, and SQLite through configured connection URLs.

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:

Live Dynamic SVG Preview

Markdown (GitHub README)

[![AllMCPs](https://allmcps.com/api/badge/pilat-mcp-datalink?style=directory)](https://allmcps.com/mcp/pilat-mcp-datalink)

HTML Embed

<a href="https://allmcps.com/mcp/pilat-mcp-datalink"><img src="https://allmcps.com/api/badge/pilat-mcp-datalink?style=directory" alt="MCP Datalink on AllMCPs" /></a>

Technical Specs & Signals

CategoryDatabases

PricingFree

4/5 checks healthy over the last 32d

60Quality signal: Good · 60/100How this signal is calculated ▾

Server availabilityNot measured

Not scored for repo-hosted servers — we can't reach the running server, only its GitHub page. Hosted MCP endpoints are health-checked live.

Verified ownership10/20

Documentation & tools27/30

Adoption & activity8/15

Community engagement0/10

A guidance signal from public completeness & health data — not a user rating. New listings start lower and rise as they add docs, get verified, and grow adoption. Signals we can't observe for a listing are skipped, not counted against it.

Supply-chain signal

No high-severity advisories surfaced by our automated scan.

Critical 0High 0Medium 0Low 0

Scanned 26d ago via OSV.dev · @pilat/mcp-datalink (npm)

★ Spotlight Slot

Feature Your MCP Server

Get maximum visibility for your server across our directory, search results, and detail pages.

Spotlight Your Server

Own this project?

This directory is pre-filled from public sources. Claim via GitHub README, site badge, or DNS TXT to unlock edit access and the Official badge — proof is checked automatically, then reviewed by our team.

Free dofollow backlink: add your website and place the AllMCPs badge on it — no claim needed. We detect it automatically and keep it verified as long as the badge stays live.

Claim & get free dofollow

Share & Embed

Add our SVG badge (dark/light directory styles) or embeddable widget to your site.

Explore more

More in 🗄️ Databases →Best MCP servers for Databases →Alternatives to MCP Datalink →Install in Claude Desktop Install in Cursor Install in VS Code

MCP Datalink

databasespostgresqlmysqlsqlitedeveloper-tools

Secure MCP database access for PostgreSQL, MySQL, and SQLite with schema inspection and constrained query execution.

Quick Install

Automated & IDE Setup

Copy the AI prompt to install this server into Claude Code, Cursor, or another agent — or use 1-click editor setup below.

Add to Cursor Add to VS Code

Not yet automatically verified

We haven't yet run this listing's install command through our automated sandbox check. This isn't a red flag — we're steadily working through the catalog.

Manual Client & Custom JSON ConfigExpand JSON ▾

Client Config & Setup

Choose your client or environment

Target File:~/Library/Application Support/Claude/claude_desktop_config.json

claude_desktop_config.json

{
  "mcpServers": {
    "pilat-mcp-datalink": {
      "command": "npx",
      "args": [
        "-y",
        "@pilat/mcp-datalink"
      ]
    }
  }
}

💡 Paste the JSON block into your client's configuration file under mcpServers, then restart the application.

Overview

Use cases

Inspect database tables, schemas, indexes, and foreign keys

Run read-only SELECT queries against configured databases

Execute INSERT, UPDATE, and DELETE statements where writes are allowed

Review query execution plans

Separate database connections with per-connection read-only settings

Key features

PostgreSQL, MySQL, and SQLite connections

Table listings with row counts

Schema, index, and foreign-key inspection

Parameterized queries with single-statement enforcement

Per-connection read-only mode

Query timeouts and response-size limits

Capabilities & Tool Schemas (6)Self-reported

Inspect callable tools, capabilities, and parameters exposed to AI agents by MCP Datalink.

list_databases

List configured database connections

list_tables

List tables with row counts

describe_table

Get schema, indexes, foreign keys

query

Run SELECT queries

execute

Run INSERT/UPDATE/DELETE

explain

Show query execution plans

Documentation Overview

@pilat/mcp-datalink

MCP server for PostgreSQL, MySQL, and SQLite. Gives AI assistants secure database access via Model Context Protocol.

Terminal

npx @pilat/mcp-datalink

Works with Claude Desktop, Claude Code, Cursor, Cline, and any MCP-compatible client.

Installation

Add to your MCP client config file (see config locations below):

config.json

{
  "mcpServers": {
    "datalink": {
      "command": "npx",
      "args": ["-y", "@pilat/mcp-datalink"],
      "env": {
        "DATALINK_ANALYTICS_URL": "postgresql://user:password@localhost:5432/analytics",
        "DATALINK_ANALYTICS_READONLY": "true",

        "DATALINK_INVENTORY_URL": "mysql://user:password@localhost:3306/inventory",

        "DATALINK_CACHE_URL": "sqlite:///path/to/cache.db"
      }
    }
  }
}

This creates three database connections: analytics (read-only), inventory, and cache.

Variable	Description
`DATALINK_{NAME}_URL`	Connection URL (creates database named `{name}`)
`DATALINK_{NAME}_READONLY`	Set to `true` to block writes
`DATALINK_{NAME}_MAX_TIMEOUT`	Max query timeout in ms (caps model requests)

Connection URL formats:

bash

# PostgreSQL
postgresql://user:password@localhost:5432/dbname
postgresql://user:password@localhost:5432/dbname?sslmode=require

# MySQL
mysql://user:password@localhost:3306/dbname
mysql://user:password@localhost:3306/dbname?ssl=true

# SQLite
sqlite:///path/to/database.db
sqlite:///Users/me/data/app.sqlite
sqlite://../relative/path/data.db

Environment Variable Substitution

URLs support ${VAR} syntax to reference other environment variables:

config.json

{
  "mcpServers": {
    "datalink": {
      "command": "npx",
      "args": ["-y", "@pilat/mcp-datalink"],
      "env": {
        "DATALINK_MAIN_URL": "${DATABASE_URL}"
      }
    }
  }
}

This allows reusing existing environment variables (like DATABASE_URL from your shell or .env file).

Supported syntax:

Syntax	Description
`${VAR}`	Expands to value of `VAR`, or keeps `${VAR}` if unset
`${VAR:-default}`	Expands to value of `VAR`, or `default` if unset

Examples:

bash

# Reference existing DATABASE_URL
DATALINK_MAIN_URL="${DATABASE_URL}"

# Build URL from parts
DATALINK_MAIN_URL="postgresql://${DB_USER}:${DB_PASS}@${DB_HOST}:5432/mydb"

# With default values
DATALINK_MAIN_URL="postgresql://localhost:${DB_PORT:-5432}/mydb"

Config File Locations

Client	Config file
Claude Code	`~/.claude.json` (global) or `.mcp.json` (project)
Claude Desktop (macOS)	`~/Library/Application Support/Claude/claude_desktop_config.json`
Claude Desktop (Windows)	`%APPDATA%\Claude\claude_desktop_config.json`
Cursor	`~/.cursor/mcp.json` or Settings → Features → MCP Servers
Cline	`cline_mcp_settings.json` or VS Code settings `cline.mcpServers`

Tools

Tool	Description
`list_databases`	List configured database connections
`list_tables`	List tables with row counts
`describe_table`	Get schema, indexes, foreign keys
`query`	Run SELECT queries
`execute`	Run INSERT/UPDATE/DELETE
`explain`	Show query execution plans

Security

Prepared statements only (no SQL injection)
Single statement per query (no chaining)
DDL blocked (no DROP, ALTER, TRUNCATE)
Readonly mode per connection
Response size limit (100 rows, 64KB default, configurable via DATALINK_MAX_TOTAL_SIZE)
Query timeout: 30s default, model can request up to 10min, MAX_TIMEOUT caps it

License

MIT

Read the full README →View source on GitHub →

Related MCP Servers

View all in Databases View all alternatives

Adoption & maintenance

Factual signals from GitHub, npm, and our automated checks — not a rating.

GitHub stars

Stargazers on the source repository.

npm downloads

230

Package downloads in the last 30 days.

Last commit

11d ago

Most recent push to the default branch.

Tools exposed

Callable tools this server registers over MCP.

Directory activity

1 views

Config copies, upvotes, and views on AllMCPs.

Reviews

No reviews yet — be the first to share how this listing worked for you.

Frequently Asked Questions about MCP Datalink

It supports PostgreSQL, MySQL, and SQLite through configured connection URLs.

AllMCPs Directory Badge

Full Badge Customizer

Showcase your server listing on GitHub or your project documentation. Embed this dynamic SVG badge to highlight official listing status and live engagement.

Badge Style:

Live Dynamic SVG Preview

Markdown (GitHub README)

[![AllMCPs](https://allmcps.com/api/badge/pilat-mcp-datalink?style=directory)](https://allmcps.com/mcp/pilat-mcp-datalink)

HTML Embed

<a href="https://allmcps.com/mcp/pilat-mcp-datalink"><img src="https://allmcps.com/api/badge/pilat-mcp-datalink?style=directory" alt="MCP Datalink on AllMCPs" /></a>

Technical Specs & Signals

CategoryDatabases

PricingFree

4/5 checks healthy over the last 32d

60Quality signal: Good · 60/100How this signal is calculated ▾

Server availabilityNot measured

Not scored for repo-hosted servers — we can't reach the running server, only its GitHub page. Hosted MCP endpoints are health-checked live.

Verified ownership10/20

Documentation & tools27/30

Adoption & activity8/15

Community engagement0/10

Supply-chain signal

No high-severity advisories surfaced by our automated scan.

Critical 0High 0Medium 0Low 0

Scanned 26d ago via OSV.dev · @pilat/mcp-datalink (npm)

★ Spotlight Slot

Feature Your MCP Server

Get maximum visibility for your server across our directory, search results, and detail pages.

Spotlight Your Server

Own this project?

Free dofollow backlink: add your website and place the AllMCPs badge on it — no claim needed. We detect it automatically and keep it verified as long as the badge stays live.

Claim & get free dofollow

Share & Embed

Add our SVG badge (dark/light directory styles) or embeddable widget to your site.

Explore more

More in 🗄️ Databases →Best MCP servers for Databases →Alternatives to MCP Datalink →Install in Claude Desktop Install in Cursor Install in VS Code