postgres-mcp-legacy/pyproject.toml at main · neverinfamous/postgres-mcp-legacy · GitHub

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
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
[project]
name = "postgres-mcp-enhanced"
version = "1.2.0"
description = "Enterprise PostgreSQL MCP Server - Enhanced fork with comprehensive security, AI-native operations, and intelligent meta-awareness"
readme = "README.md"
requires-python = ">=3.12"
dependencies = [
    "mcp[cli]>=1.25.0",
    "psycopg[binary]>=3.2.6",
    "humanize>=4.15.0",
    "pglast==7.11",
    "attrs>=25.3.0",
    "psycopg-pool>=3.2.6",
    "instructor>=1.14.1",
    "h11>=0.16.0",
    "setuptools>=78.1.1",
    # Security: Force updated versions to fix CVEs
    "starlette>=0.51.0",  # CVE-2025-62727, CVE-2025-54121
    "urllib3>=2.6.3",     # CVE-2026-21441 (data amplification attack)
    "requests>=2.32.4",   # CVE-2024-47081
    "aiohttp>=3.13.3",    # CVE-2025-69223 + 7 security fixes
    "filelock>=3.20.1",   # CVE-2025-68146 (race condition fix)
    "certifi>=2026.1.4",  # Updated SSL certificates
]
license = "mit"
license-files = ["LICENSE"]
keywords = ["mcp", "postgresql", "database", "postgres", "model-context-protocol", "pgvector", "postgis"]
classifiers = [
    "Development Status :: 5 - Production/Stable",
    "Intended Audience :: Developers",
    "License :: OSI Approved :: MIT License",
    "Operating System :: OS Independent",
    "Programming Language :: Python :: 3",
    "Programming Language :: Python :: 3.12",
    "Programming Language :: Python :: 3.13",
    "Programming Language :: Python :: 3.14",
    "Topic :: Database",
    "Topic :: Software Development :: Libraries :: Python Modules",
]

[[project.authors]]
name = "Chris LeRoux"
email = "admin@adamic.tech"

[project.urls]
Homepage = "https://github.com/neverinfamous/postgres-mcp"
Repository = "https://github.com/neverinfamous/postgres-mcp"
Issues = "https://github.com/neverinfamous/postgres-mcp/issues"
Documentation = "https://github.com/neverinfamous/postgres-mcp/wiki"

[build-system]
requires = [ "hatchling",]
build-backend = "hatchling.build"

[tool.hatch.build.targets.wheel]
packages = ["src/postgres_mcp"]

[project.scripts]
postgres-mcp = "postgres_mcp:main"

# [tool.pyright]
# venvPath = "."
# venv = ".venv"

[tool.pytest.ini_options]
pythonpath = ["./src"]
asyncio_mode = "auto"
asyncio_default_fixture_loop_scope = "function"

[dependency-groups]
dev = [
    "docker>=7.1.0",
    "pyright==1.1.408",
    "pytest-asyncio>=0.26.0",
    "pytest>=8.3.5",
    "ruff==0.14.11",
]

[tool.black]
line-length = 150

[tool.ruff]
line-length = 150
target-version = "py38"
exclude = [".venv*"]

lint.select = [
    "E",   # pycodestyle errors
    "F",   # pyflakes
    "I",   # isort
    "B",   # flake8-bugbear
    "W",   # pycodestyle warnings
    # "C90", # mccabe complexity
    "N",   # pep8-naming
    # "D",   # pydocstyle
    "UP",  # pyupgrade
    "RUF"  # ruff-specific rules
]

[tool.ruff.format]
quote-style = "double"
indent-style = "space"
line-ending = "auto"

[tool.ruff.lint.pydocstyle]
convention = "google"

[tool.ruff.lint.isort]
force-single-line = true
known-first-party = ["postgres-mcp"]

[tool.pyright]
typeCheckingMode = "strict"
pythonVersion = "3.12"  # Minimum for type checking, runtime supports 3.12-3.14, Docker uses 3.13
reportMissingTypeStubs = false
# reportUnknownMemberType = true
# reportUnknownParameterType = true
# reportUnknownVariableType = true
# reportUnknownArgumentType = true
reportPrivateUsage = true
reportUntypedFunctionDecorator = true
reportMissingTypeArgument = true
reportInvalidTypeVarUse = true
reportUnnecessaryCast = true
# reportUnnecessaryComparison = true