mcp-postgres 3.1.0

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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106

[package]
name = "mcp-postgres"
version = "3.1.0"
edition = "2021"
authors = ["Piyush"]
description = "High-performance MCP server for PostgreSQL with CPU-aware connection pooling and optimized buffers"
repository = "https://github.com/corporatepiyush/mcp-pg-rust"
homepage = "https://github.com/corporatepiyush/mcp-pg-rust"
license = "Apache-2.0"
readme = "README.md"
keywords = ["mcp", "postgresql", "database", "server", "json-rpc"]
categories = ["database", "web-programming::http-server"]
include = ["src/", "bin/", "tools.json", "Cargo.toml", "README.md", "schema.sql"]

[dependencies]
# PostgreSQL
tokio = { version = "1.41", features = ["macros", "rt-multi-thread", "io-util", "net", "time", "sync", "io-std"] }
tokio-postgres = { version = "0.7", features = ["with-serde_json-1"] }
deadpool = "0.12"
deadpool-postgres = "0.14"

# HTTP/2 and SSE
axum = "0.7"
hyper = { version = "1.0", features = ["full"] }
futures = "0.3"
tokio-stream = "0.1"

# JSON-RPC and Protocol
serde = { version = "1.0", features = ["derive"] }
serde_json = "1.0"
lru = "0.12"

# Utilities
uuid = { version = "1.10", features = ["v4"] }
crossbeam = { version = "0.8", features = ["crossbeam-queue"] }
once_cell = "1.20"
fake = { version = "5.1" }
dashmap = "6.0"
parking_lot = "0.12"

# Logging
tracing = "0.1"
tracing-subscriber = { version = "0.3", features = ["env-filter", "fmt"] }

# Error Handling
thiserror = "1.0"
anyhow = "1.0"

# Metrics
prometheus = { version = "0.13", default-features = false }

# CLI
clap = { version = "4.5", features = ["derive"] }

# Memory Allocator (wraps mimalloc C library - currently v2.1.x with v2 features)
mimalloc = { version = "0.1", features = ["local_dynamic_tls", "extended", "override"] }

# System (TCP socket options, CPU detection)
libc = "0.2"
num_cpus = "1.16"

# HTTP Client for latency testing
reqwest = { version = "0.11", features = ["json"] }

[dev-dependencies]
tokio-test = "0.4"
criterion = "0.5"

# Latest minor version fetches
# Run: cargo update --aggressive

[[bin]]
name = "mcp-postgres"
path = "src/main.rs"

[[bin]]
name = "generate_load"
path = "bin/generate_load.rs"

[[bin]]
name = "batch_load"
path = "bin/batch_load.rs"

[[bin]]
name = "benchmark"
path = "bin/benchmark.rs"

[[bin]]
name = "load_test_data"
path = "bin/load_test_data.rs"

[[bin]]
name = "measure_latency"
path = "bin/measure_latency.rs"

[profile.release]
opt-level = 3
lto = "fat"
codegen-units = 1
strip = true
panic = "abort"
overflow-checks = false

[profile.bench]
inherits = "release"
debug = true