Mcp Postgres Simple — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Mcp Postgres Simple (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
A Model Context Protocol (MCP) server that provides tools for querying and inspecting a PostgreSQL database.
pip (Python package installer) pip install -r requirements.txt.env.example to .env: cp .env.example .env # On Windows: copy .env.example .env.env and fill in your PostgreSQL credentials: DB_HOST=localhost
DB_PORT=5432
DB_NAME=your_database
DB_USER=your_username
DB_PASSWORD=your_passwordTo run the server locally for testing:
python server.pyYou can verify your database connection configuration using the included test script:
python test_connection.pyAdd the server configuration to your MCP client settings:
{
"mcpServers": {
"postgres": {
"command": "python",
"args": ["/path/to/mcp-postgres-simple/server.py"]
}
}
}execute_query(query: str): Execute a SQL querylist_schemas(): List all non-system schemaslist_tables(schema: str = None): List tables in database or specific schemadescribe_table(table_name: str, schema: str = 'public'): Get column details for a table~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.