mcp-postgres 4.0.4

High-performance MCP server for PostgreSQL with CPU-aware connection pooling and optimized buffers
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62

pub mod actions;
pub mod config;
pub mod errors;
pub mod http;
pub mod lockfree_pool;
pub mod metrics;
pub mod pool;
pub mod protocol;
pub mod server;
pub mod tools;
pub mod validation;

use clap::Parser;

#[derive(Parser, Debug)]
#[command(name = "MCP PostgreSQL Server")]
#[command(about = "High-performance Model Context Protocol server for PostgreSQL", long_about = None)]
pub struct Args {
    /// PostgreSQL connection string
    #[arg(short, long)]
    pub database_url: Option<String>,

    /// Server host
    #[arg(short = 'H', long, default_value = "127.0.0.1")]
    pub host: String,

    /// TCP server port
    #[arg(short = 'p', long, default_value = "3000")]
    pub port: u16,

    /// HTTP server port
    #[arg(long, default_value = "3001")]
    pub http_port: u16,

    /// Minimum pool connections (default: 1)
    #[arg(long)]
    pub min_connections: Option<u32>,

    /// Maximum pool connections (default: 8 * num_cpus)
    #[arg(long)]
    pub max_connections: Option<u32>,

    /// Log level
    #[arg(short, long, default_value = "info")]
    pub log_level: String,

    /// Enable metrics endpoint
    #[arg(long)]
    pub enable_metrics: bool,

    /// Metrics port
    #[arg(long, default_value = "9090")]
    pub metrics_port: u16,

    /// Run in stdio mode for MCP compatibility (Claude Desktop)
    #[arg(long)]
    pub stdio: bool,

    /// Access mode: unrestricted (full read/write) or restricted (read-only)
    #[arg(long, default_value = "unrestricted")]
    pub access_mode: config::AccessMode,
}