Database MCP Server

Pricing

Rating

Developer

Actor stats

Categories

Share

MCP Server for AI database access. Connect to PostgreSQL, MySQL, or SQLite. Query data, inspect schemas, manage tables. 11 tools for complete database intelligence.

Features

• Multi-database - PostgreSQL, MySQL, SQLite
• Query execution - SELECT with automatic LIMIT protection
• Schema inspection - Tables, columns, foreign keys, indexes
• Safe operations - Separate read (query) and write (execute) tools
• Cloud-ready - Secure connections via Apify infrastructure

Input Parameters

Tools

Examples

Connect to PostgreSQL

{
"tool":"db.connect",
"dbType":"postgresql",
"connectionString":"postgresql://user:pass@host:5432/dbname"
}

Or with individual parameters:

{
"tool":"db.connect",
"dbType":"postgresql",
"host":"your-host.com",
"port":5432,
"database":"mydb",
"user":"myuser",
"password":"mypassword",
"ssl":true
}

Connect to MySQL

{
"tool":"db.connect",
"dbType":"mysql",
"host":"your-mysql-host.com",
"port":3306,
"database":"mydb",
"user":"myuser",
"password":"mypassword"
}

Connect to SQLite (URL)

{
"tool":"db.connect",
"dbType":"sqlite",
"sqliteUrl":"https://example.com/database.db"
}

Query Data

{
"tool":"db.query",
"dbType":"postgresql",
"connectionString":"postgresql://...",
"query":"SELECT * FROM users WHERE active = true",
"limit":100
}

Get Schema

{
"tool":"db.get_schema",
"dbType":"postgresql",
"connectionString":"postgresql://..."
}

Describe Table

{
"tool":"db.describe_table",
"dbType":"postgresql",
"connectionString":"postgresql://...",
"tableName":"users"
}

Execute Statement

{
"tool":"db.execute",
"dbType":"postgresql",
"connectionString":"postgresql://...",
"query":"INSERT INTO logs (message) VALUES ('Hello World')"
}

Output Schema

Success Response

{
"type":"tool_result",
"tool":"db.query",
"status":"success",
"data":{
"rows":[...],
"fields":["column1","column2"]
},
"rowCount":10,
"executionTime":45
}

Error Response

{
"type":"tool_result",
"tool":"db.query",
"status":"error",
"error":"relation \"users\" does not exist"
}

MCP Integration

Claude Desktop

{
"mcpServers":{
"database":{
"command":"npx",
"args":["-y","@anthropic/apify-mcp-client","constant_quadruped/database-mcp-server"]
}
}
}

Apify Client (JavaScript)

import{ ApifyClient }from'apify-client';
const client =newApifyClient({token:'YOUR_TOKEN'});
const run =await client.actor('constant_quadruped/database-mcp-server').call({
tool:'db.query',
dbType:'postgresql',
connectionString:'postgresql://user:pass@host:5432/db',
query:'SELECT * FROM users LIMIT 10'
});
const{ items }=await client.dataset(run.defaultDatasetId).listItems();
console.log(items);

Apify Client (Python)

from apify_client import ApifyClient
client = ApifyClient("YOUR_TOKEN")
run = client.actor("constant_quadruped/database-mcp-server").call(run_input={
"tool":"db.query",
"dbType":"postgresql",
"connectionString":"postgresql://user:pass@host:5432/db",
"query":"SELECT * FROM users LIMIT 10"
})
items = client.dataset(run["defaultDatasetId"]).list_items().items
print(items)

Use Cases

• Data exploration - Understand database structure
• Report generation - Query data for AI reports
• Schema documentation - Auto-generate database docs
• Data migration - Inspect source and target schemas
• Debugging - Query logs and metrics tables

Security

• Passwords and connection strings marked as secrets
• SSL enabled by default for PostgreSQL and MySQL
• Query results limited to prevent memory issues
• Separate read (query) and write (execute) operations

License

MIT