Home / crystaldba / postgres-mcp
AI Slop Code RIsk Monitor

crystaldba/postgres-mcp

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

33.0 High pattern signal View on GitHub

Maintenance and Governance Review

This report summarizes scanner evidence for crystaldba/postgres-mcp, a Python project with 3,389 GitHub stars. SynthScan examined 14,935 lines of code across 56 source files, recording 401 pattern matches distributed across 10 syntactic categories. The legacy adjusted pattern signal is 33.0 (High pattern signal); it is not an authorship estimate.

Use the findings to ask whether maintainers can explain intent, verify dependencies, simplify unnecessary scaffolding, and focus review effort. Risk Payload v1 adds ownership, supply-chain, over-engineering, and review-effort vectors when available. These are prompts for human verification, not probabilities, security findings, or measured maintenance costs.

33.0
Adjusted Signal
33.0
Raw Pattern Score
100%
Time Factor
2026-08-17
Last Push
3.4K
Stars
Python
Language
14.9K
Lines of Code
56
Files
401
Pattern Hits
2026-10-12
Scan Date
0.05
HC Hit Rate

Risk Review · v3

Use each vector to guide manual verification of the underlying findings.

Cognitive Ownership Risk 69.7/100 · HIGH

Can maintainers explain intent, assumptions, and trade-offs? 275 finding(s).

Hallucinated Dependency & Supply Chain Risk 7.1/100 · LOW

Are imports declared and package/API names verified? 22 finding(s).

Agent Over-Engineering Ratio 59.2/100 · HIGH

Are wrappers, guards, and repeated structures necessary? 267 finding(s).

PR Review Velocity Impact 81.5/100 · CRITICAL

Which changes need focused human review? 401 finding(s).

What These Metrics Mean

Adjusted Signal
Legacy pattern score normalized per 1,000 scanned lines and multiplied by the repository-level time factor. It is not an estimate of AI authorship.
Raw Pattern Score
Sum of severity- and context-weighted pattern findings before applying the time factor.
Time Factor
A coarse multiplier based on repository last-push metadata. It does not identify when individual code was written.
Pattern Hits
Count of configured pattern findings. Review each location and surrounding code before acting.
HC Hit Rate
High- and critical-severity findings per scanned file. Severity is a configured detector weight, not proof of a vulnerability or authorship.
Lines / Files
Scan coverage denominators used by the legacy normalized score.

Pattern-Signal History

This chart tracks the legacy adjusted pattern score across scan runs. Changes can reflect source changes, scan coverage, or detector/scoring versions; they do not measure AI adoption or prove that a team refactored code. Compare runs only when their scoring versions are compatible. The dashed line tracks the raw pattern-hit count.

Severity Breakdown

Groups findings by configured severity weight. Severity is not a confidence estimate, security rating, or proof that a package is missing. Verify imports against the project's manifests and inspect each finding in its local design context.

CRITICAL 0HIGH 3MEDIUM 44LOW 354

Directory Score Breakdown

This horizontal bar chart shows where configured pattern scores accumulate across directories. Treat the bars as locations to inspect, not as evidence of authorship or code quality. Use the file-level findings to decide whether a directory needs a focused ownership, dependency, complexity, or review check.

Pattern Findings

The scanner identified 401 distinct pattern matches across 10 syntactic categories. Each entry below represents a discrete location in the source code where the engine recorded a detector match to inspect in context. Expand any category row to inspect the individual file paths, line numbers, code snippets, and the lexical context (CODE, COMMENT, or STRING) in which each match was detected.

Reading the findings table: The Severity column indicates the configured finding weight (CRITICAL / HIGH / MEDIUM / LOW). The Context column identifies whether the match occurred inside executable code, an inline comment, or a string literal — legacy comment-context matches receive a ×1.5 score weight. The ⚡ bolt icon marks clustered matches: three or more patterns within a 10-line window, each receiving an additional ×1.5 density multiplier under the legacy scoring model.

Hyper-Verbose Identifiers163 hits · 154 pts
SeverityFileLineSnippetContext
LOWtests/conftest.py21def test_postgres_connection_string(request) -> Generator[tuple[str, str], None, None]:CODE
LOWtests/utils.py15def create_postgres_container(version: str) -> Generator[Tuple[str, str], None, None]:CODE
LOWtests/unit/test_transport.py10async def test_transport_argument_parsing(transport):CODE
LOWtests/unit/test_transport.py48async def test_streamable_http_host_port_arguments():CODE
LOWtests/unit/test_transport.py77async def test_sse_host_port_arguments():CODE
LOWtests/unit/test_transport.py106async def test_default_transport_is_stdio():CODE
LOWtests/unit/test_access_mode.py31async def test_get_sql_driver_returns_correct_driver(access_mode, expected_driver_type, mock_db_connection):CODE
LOWtests/unit/test_access_mode.py47async def test_get_sql_driver_sets_timeout_in_restricted_mode(mock_db_connection):CODE
LOWtests/unit/test_access_mode.py60async def test_get_sql_driver_in_unrestricted_mode_no_timeout(mock_db_connection):CODE
LOWtests/unit/test_access_mode.py72async def test_command_line_parsing():CODE
LOWtests/unit/top_queries/test_top_queries_calc.py99def mock_extension_not_installed():CODE
LOWtests/unit/top_queries/test_top_queries_calc.py185async def test_extension_not_installed(mock_pg13_driver, mock_extension_not_installed):CODE
LOWtests/unit/explain/test_server_integration.py35async def test_explain_query_integration():CODE
LOWtests/unit/explain/test_server_integration.py57async def test_explain_query_with_analyze_integration():CODE
LOWtests/unit/explain/test_server_integration.py79async def test_explain_query_with_hypothetical_indexes_integration():CODE
LOWtests/unit/explain/test_server_integration.py110async def test_explain_query_missing_hypopg_integration():CODE
LOWtests/unit/explain/test_server_integration.py141async def test_explain_query_error_handling_integration():CODE
LOWtests/unit/explain/test_server.py27async def test_server_tools_registered():CODE
LOWtests/unit/explain/test_server.py58async def test_explain_query_analyze():CODE
LOWtests/unit/explain/test_server.py86async def test_explain_query_hypothetical_indexes():CODE
LOWtests/unit/explain/test_server.py116async def test_explain_query_error_handling():CODE
LOWtests/unit/explain/test_explain_plan.py27async def test_explain_plan_tool_initialization(mock_sql_driver):CODE
LOWtests/unit/explain/test_explain_plan.py48async def test_has_like_expressions():CODE
LOWtests/unit/explain/test_explain_plan.py93async def test_explain_with_bind_variables(mock_sql_driver):CODE
LOWtests/unit/explain/test_explain_plan.py203async def test_explain_analyze_with_bind_variables(mock_sql_driver, monkeypatch):CODE
LOWtests/unit/explain/test_explain_plan.py258async def test_explain_analyze_success(mock_sql_driver):CODE
LOWtests/unit/explain/test_explain_plan.py307async def test_explain_with_invalid_response(mock_sql_driver):CODE
LOWtests/unit/explain/test_explain_plan.py323async def test_explain_with_empty_result(mock_sql_driver):CODE
LOWtests/unit/explain/test_explain_plan.py337async def test_explain_with_empty_plan_data(mock_sql_driver):CODE
LOWtests/unit/explain/test_explain_plan.py418async def test_explain_with_functional_hypothetical_indexes(mock_sql_driver):CODE
LOWtests/unit/explain/test_explain_plan_real_db.py109async def test_explain_with_real_db(local_sql_driver):CODE
LOWtests/unit/explain/test_explain_plan_real_db.py136async def test_explain_analyze_with_real_db(local_sql_driver):CODE
LOWtests/unit/explain/test_explain_plan_real_db.py162async def test_explain_join_query_with_real_db(local_sql_driver):CODE
LOWtests/unit/explain/test_explain_plan_real_db.py190async def test_explain_with_bind_variables_real_db(local_sql_driver):STRING
LOWtests/unit/explain/test_explain_plan_real_db.py209async def test_explain_with_like_expressions_real_db(local_sql_driver):CODE
LOWtests/unit/explain/test_explain_plan_real_db.py231async def test_explain_with_like_and_bind_variables_real_db(local_sql_driver):CODE
LOWtests/unit/explain/test_explain_plan_real_db.py250async def test_explain_invalid_query_with_real_db(local_sql_driver):CODE
LOW⚡tests/unit/index/test_dta_calc.py44async def test_extract_columns_empty_query(create_dta):CODE
LOW⚡tests/unit/index/test_dta_calc.py52async def test_extract_columns_invalid_sql(create_dta):CODE
LOW⚡tests/unit/index/test_dta_calc.py60async def test_extract_columns_subquery(create_dta):CODE
LOW⚡tests/unit/index/test_dta_calc.py68async def test_index_initialization():CODE
LOWtests/unit/index/test_dta_calc.py94async def test_extract_columns_from_simple_query(create_dta):CODE
LOWtests/unit/index/test_dta_calc.py103async def test_extract_columns_from_join_query(create_dta):CODE
LOWtests/unit/index/test_dta_calc.py370async def test_filter_long_text_columns(async_sql_driver, create_dta):CODE
LOWtests/unit/index/test_dta_calc.py462async def test_basic_workload_analysis(async_sql_driver):CODE
LOWtests/unit/index/test_dta_calc.py584async def test_replace_parameters_basic(create_dta):CODE
LOWtests/unit/index/test_dta_calc.py608async def test_replace_parameters_numeric(create_dta):CODE
LOWtests/unit/index/test_dta_calc.py636async def test_replace_parameters_date(create_dta):CODE
LOWtests/unit/index/test_dta_calc.py657async def test_replace_parameters_like(create_dta):CODE
LOWtests/unit/index/test_dta_calc.py678async def test_replace_parameters_multiple(create_dta):CODE
LOWtests/unit/index/test_dta_calc.py691 def identify_column_side_effect(context, table_columns: Dict[str, Set[str]]):CODE
LOWtests/unit/index/test_dta_calc.py775async def test_identify_parameter_column(create_dta):CODE
LOWtests/unit/index/test_dta_calc.py810async def test_get_replacement_value(create_dta):CODE
LOWtests/unit/index/test_dta_calc.py848async def test_condition_column_collector_simple(async_sql_driver):CODE
LOWtests/unit/index/test_dta_calc.py865async def test_condition_column_collector_join(async_sql_driver):CODE
LOWtests/unit/index/test_dta_calc.py1008async def test_extract_condition_columns(async_sql_driver):CODE
LOWtests/unit/index/test_dta_calc.py736async def test_replace_parameters_fallback(create_dta):STRING
LOWtests/unit/index/test_dta_calc.py893async def test_condition_column_collector_with_alias(async_sql_driver):STRING
LOWtests/unit/index/test_dta_calc.py929async def test_complex_query_with_alias_in_conditions(async_sql_driver):STRING
LOWtests/unit/index/test_dta_calc.py972async def test_filter_candidates_by_query_conditions(async_sql_driver, create_dta):STRING
103 more matches not shown…
Self-Referential Comments40 hits · 121 pts
SeverityFileLineSnippetContext
MEDIUMdocker-entrypoint.sh36# Create a new array for the processed argumentsCOMMENT
MEDIUMtests/conftest.py13# Define a custom event loop policy that handles cleanup betterCOMMENT
MEDIUMtests/unit/top_queries/test_top_queries_calc.py115 # Create the TopQueriesCalc instance with the mock driverCOMMENT
MEDIUMtests/unit/top_queries/test_top_queries_calc.py133 # Create the TopQueriesCalc instance with the mock driverCOMMENT
MEDIUMtests/unit/top_queries/test_top_queries_calc.py151 # Create the TopQueriesCalc instance with the mock driverCOMMENT
MEDIUMtests/unit/top_queries/test_top_queries_calc.py169 # Create the TopQueriesCalc instance with the mock driverCOMMENT
MEDIUMtests/unit/top_queries/test_top_queries_calc.py187 # Create the TopQueriesCalc instance with the mock driverCOMMENT
MEDIUMtests/unit/top_queries/test_top_queries_calc.py207 # Create the TopQueriesCalc instance with the mock driverCOMMENT
MEDIUMtests/unit/top_queries/test_top_queries_calc.py220 # Create the TopQueriesCalc instance with the mock driverCOMMENT
MEDIUMtests/unit/top_queries/test_top_queries_calc.py240 # Create the TopQueriesCalc instance with the mock driverCOMMENT
MEDIUMtests/unit/explain/test_server.py118 # Create a mock error responseCOMMENT
MEDIUMtests/unit/index/test_dta_calc.py1195 # Create a before plan with sequential scanCOMMENT
MEDIUMtests/unit/index/test_dta_calc.py1219 # Create an after plan with index scan insteadCOMMENT
MEDIUMtests/unit/database_health/test_database_health_tool.py85 # Create a duplicate index to test duplicate index detectionCOMMENT
MEDIUMtests/unit/sql/test_db_conn_pool.py67 # Create a mock implementation of pool_connect that simulates a retryCOMMENT
MEDIUMtests/unit/sql/test_sql_driver.py52 # Create the poolCOMMENT
MEDIUMtests/unit/sql/test_sql_driver.py100 # Create a mock implementation of _execute_with_connectionCOMMENT
MEDIUMtests/unit/sql/test_sql_driver.py151 # Create a mock implementation of _execute_with_connectionCOMMENT
MEDIUMtests/unit/sql/test_sql_driver.py227 # Create a mock implementation of _execute_with_connectionCOMMENT
MEDIUMtests/unit/sql/test_sql_driver.py268 # Create a mock implementation of _execute_with_connectionCOMMENT
MEDIUMtests/unit/sql/test_sql_driver.py308 # Create a mock execute functionCOMMENT
MEDIUMtests/unit/sql/test_readonly_enforcement.py24 # Create a mock for the base SqlDriver._execute_with_connectionCOMMENT
MEDIUMtests/integration/test_top_queries_integration.py121 # Create the TopQueriesCalc instanceCOMMENT
MEDIUMtests/integration/test_top_queries_integration.py153 # Create the TopQueriesCalc instanceCOMMENT
MEDIUM⚡tests/integration/dta/test_dta_calc_integration.py1085 # Create a simple test tableCOMMENT
MEDIUM⚡tests/integration/dta/test_dta_calc_integration.py1176 # Create a test table with columns of varying sizesCOMMENT
MEDIUMtests/integration/dta/test_dta_calc_integration.py1314 # Create a test table with characteristics that demonstrate Pareto optimalityCOMMENT
MEDIUMtests/integration/dta/test_dta_calc_integration.py1348 # Create a workload with specific benefit profilesCOMMENT
MEDIUM⚡tests/integration/dta/test_dta_calc_integration.py821 # Create the recommended indexesSTRING
MEDIUMtests/integration/dta/test_dta_calc_integration.py480 # Create the recommended indexesSTRING
MEDIUMsrc/postgres_mcp/artifacts.py209 # Create a PlanNode from the raw JSON dataCOMMENT
MEDIUMsrc/postgres_mcp/explain/explain_plan.py204 # Create the indexes queryCOMMENT
MEDIUMsrc/postgres_mcp/index/dta_calc.py403 # Create a list of table names for the queryCOMMENT
MEDIUM⚡src/postgres_mcp/index/index_opt_base.py505 # Create a hashable key for the cacheCOMMENT
MEDIUMsrc/postgres_mcp/index/index_opt_base.py243 # Create a synthetic workload entry for each queryCOMMENT
MEDIUMsrc/postgres_mcp/index/index_opt_base.py375 # Create a cache key from the query and indexesCOMMENT
MEDIUMsrc/postgres_mcp/index/presentation.py155 # Create the result JSON object with summary, recommendations, and query impactCOMMENT
MEDIUMsrc/postgres_mcp/index/llm_opt.py270 # Create a hypothetical index using hypopgCOMMENT
MEDIUMsrc/postgres_mcp/index/llm_opt.py345 # Create a new Index object with the columnsCOMMENT
MEDIUMsrc/postgres_mcp/sql/bind_params.py554 # Create a cache key from table and column nameCOMMENT
Excessive Try-Catch Wrapping78 hits · 76 pts
SeverityFileLineSnippetContext
LOWtests/utils.py57 except Exception as e:CODE
LOWtests/utils.py118 except Exception as e:CODE
LOW⚡tests/utils.py139 except Exception as e:CODE
LOW⚡tests/utils.py145 except Exception:CODE
LOW⚡tests/utils.py154 except Exception as e:CODE
LOWtests/unit/test_access_mode.py105 except Exception:CODE
LOWtests/integration/test_top_queries_integration.py42 except Exception as e:CODE
LOW⚡tests/integration/test_top_queries_integration.py94 except Exception as e:STRING
LOW⚡tests/integration/test_top_queries_integration.py104 except Exception as e:CODE
LOW⚡tests/integration/dta/test_dta_calc_integration.py1166 except Exception as e:CODE
LOWtests/integration/dta/test_dta_calc_integration.py58 except Exception as e:CODE
LOWtests/integration/dta/test_dta_calc_integration.py65 except Exception as e:CODE
LOW⚡tests/integration/dta/test_dta_calc_integration.py818 except Exception as e:STRING
LOW⚡tests/integration/dta/test_dta_calc_integration.py828 except Exception as e:STRING
LOW⚡tests/integration/dta/test_dta_calc_integration.py1074 except Exception as e:STRING
LOWtests/integration/dta/test_dta_calc_integration.py546 except Exception as e:STRING
LOWtests/integration/dta/test_dta_calc_integration.py731 except Exception as e:STRING
LOWtests/integration/dta/test_dta_calc_integration.py840 except Exception as e:STRING
LOWtests/integration/dta/test_dta_calc_integration.py850 except Exception as e:STRING
LOWsrc/postgres_mcp/server.py111 except Exception as e:CODE
LOWsrc/postgres_mcp/server.py185 except Exception as e:CODE
LOWsrc/postgres_mcp/server.py324 except Exception as e:CODE
LOW⚡src/postgres_mcp/server.py387 except Exception:CODE
LOW⚡src/postgres_mcp/server.py393 except Exception:CODE
LOW⚡src/postgres_mcp/server.py399 except Exception:CODE
LOW⚡src/postgres_mcp/server.py409 except Exception as e:CODE
LOWsrc/postgres_mcp/server.py425 except Exception as e:CODE
LOWsrc/postgres_mcp/server.py452 except Exception as e:CODE
LOWsrc/postgres_mcp/server.py485 except Exception as e:CODE
LOWsrc/postgres_mcp/server.py552 except Exception as e:CODE
LOWsrc/postgres_mcp/server.py640 except Exception as e:CODE
LOWsrc/postgres_mcp/server.py690 except Exception as e:CODE
LOWsrc/postgres_mcp/artifacts.py220 except Exception as e:CODE
LOWsrc/postgres_mcp/artifacts.py322 except Exception as e:CODE
LOWsrc/postgres_mcp/top_queries/top_queries_calc.py152 except Exception as e:STRING
LOWsrc/postgres_mcp/top_queries/top_queries_calc.py247 except Exception as e:STRING
LOWsrc/postgres_mcp/explain/explain_plan.py112 except Exception as e:CODE
LOW⚡src/postgres_mcp/explain/explain_plan.py138 except Exception as e:CODE
LOW⚡src/postgres_mcp/explain/explain_plan.py141 except Exception as e:CODE
LOW⚡src/postgres_mcp/explain/explain_plan.py180 except Exception as e:CODE
LOW⚡src/postgres_mcp/explain/explain_plan.py182 except Exception as e:CODE
LOWsrc/postgres_mcp/explain/explain_plan.py236 except Exception as e:CODE
MEDIUMsrc/postgres_mcp/index/dta_calc.py511def in existing_defs:CODE
LOW⚡src/postgres_mcp/index/dta_calc.py367 except Exception as e:CODE
LOWsrc/postgres_mcp/index/dta_calc.py577 except Exception as e:CODE
LOWsrc/postgres_mcp/index/dta_calc.py624 except Exception as e:CODE
LOWsrc/postgres_mcp/index/dta_calc.py527 except Exception as e:STRING
LOWsrc/postgres_mcp/index/dta_calc.py531 except Exception as e:STRING
LOW⚡src/postgres_mcp/index/index_opt_base.py500 except Exception as e:CODE
LOWsrc/postgres_mcp/index/index_opt_base.py287 except Exception as e:CODE
LOWsrc/postgres_mcp/index/index_opt_base.py410 except Exception as e:CODE
LOWsrc/postgres_mcp/index/index_opt_base.py488 except Exception as e:CODE
LOWsrc/postgres_mcp/index/index_opt_base.py646 except Exception as e:CODE
LOWsrc/postgres_mcp/index/index_opt_base.py662 except Exception as e:CODE
LOWsrc/postgres_mcp/index/index_opt_base.py532 except Exception as e:STRING
LOWsrc/postgres_mcp/index/presentation.py168 except Exception as e:CODE
LOWsrc/postgres_mcp/index/llm_opt.py223 except Exception as e:CODE
LOWsrc/postgres_mcp/index/llm_opt.py288 except Exception as e:CODE
LOWsrc/postgres_mcp/index/llm_opt.py382 except Exception as e:STRING
LOWsrc/postgres_mcp/database_health/replication_calc.py110 except Exception:STRING
18 more matches not shown…
Redundant / Tautological Comments26 hits · 39 pts
SeverityFileLineSnippetContext
LOWdocker-entrypoint.sh65# Check if SSE transport is specified and --sse-host is not already setCOMMENT
LOWtests/utils.py36 # Check if custom image already existsCOMMENT
LOWtests/utils.py94 # Check if container is runningCOMMENT
LOWtests/integration/test_top_queries_integration.py34 # Check if extension existsCOMMENT
LOWtests/integration/dta/test_dta_calc_integration.py780 # Check if it matches one of our expected patternsSTRING
LOWtests/integration/dta/test_dta_calc_integration.py784 # Check if recommendation matches at least as a superset of the patternSTRING
LOWtests/integration/dta/test_dta_calc_integration.py875 # Check if we measured performance improvementsSTRING
LOW⚡src/postgres_mcp/explain/explain_plan.py125 # Check if the query contains bind variablesCOMMENT
LOW⚡src/postgres_mcp/explain/explain_plan.py131 # Check if we got a valid planCOMMENT
LOW⚡src/postgres_mcp/index/dta_calc.py377 # Check if all columns in the index are used in conditionsCOMMENT
LOW⚡src/postgres_mcp/index/dta_calc.py764 # Check if this is a known aliasCOMMENT
LOWsrc/postgres_mcp/index/dta_calc.py323 # Check if we've exceeded the time limit after doing at least one iterationCOMMENT
LOWsrc/postgres_mcp/index/dta_calc.py566 # Check if uniqueCOMMENT
LOWsrc/postgres_mcp/index/dta_calc.py792 # Check if this is a reference to a column aliasCOMMENT
LOW⚡src/postgres_mcp/index/index_opt_base.py508 # Check if we already have a cached resultCOMMENT
LOWsrc/postgres_mcp/index/index_opt_base.py149 # Output resultsCOMMENT
LOWsrc/postgres_mcp/index/index_opt_base.py626 # Check if we have a cached resultCOMMENT
LOWsrc/postgres_mcp/index/llm_opt.py309 # Check if this is an index scan nodeCOMMENT
LOWsrc/postgres_mcp/sql/bind_params.py164 # Check if this is a known aliasCOMMENT
LOWsrc/postgres_mcp/sql/bind_params.py557 # Check if we already have this in cacheCOMMENT
LOWsrc/postgres_mcp/sql/extension_utils.py45 # Check if we have a cached versionCOMMENT
LOWsrc/postgres_mcp/sql/extension_utils.py114 # Check if the extension is installedCOMMENT
LOWsrc/postgres_mcp/sql/extension_utils.py142 # Check if the extension is available but not installedCOMMENT
LOWsrc/postgres_mcp/sql/sql_driver.py162 # Check if this is a connection poolCOMMENT
LOWsrc/postgres_mcp/sql/safe_sql.py880 # Check if node type is allowedCOMMENT
LOWsrc/postgres_mcp/sql/safe_sql.py962 # Check if the inner statement type is allowedCOMMENT
Deep Nesting39 hits · 33 pts
SeverityFileLineSnippetContext
LOWtests/utils.py15CODE
LOWtests/unit/test_transport.py10CODE
LOWtests/unit/index/test_dta_calc.py170CODE
LOWtests/unit/index/test_dta_calc.py171CODE
LOWtests/unit/sql/test_db_conn_pool.py62CODE
LOWtests/integration/dta/test_dta_calc_integration.py170CODE
LOWtests/integration/dta/test_dta_calc_integration.py552CODE
LOWtests/integration/dta/test_dta_calc_integration.py885CODE
LOWtests/integration/dta/test_dta_calc_integration.py1080CODE
LOWsrc/postgres_mcp/server.py123CODE
LOWsrc/postgres_mcp/server.py197CODE
LOWsrc/postgres_mcp/server.py336CODE
LOWsrc/postgres_mcp/explain/explain_plan.py83CODE
LOWsrc/postgres_mcp/index/dta_calc.py125CODE
LOWsrc/postgres_mcp/index/dta_calc.py344CODE
LOWsrc/postgres_mcp/index/dta_calc.py384CODE
LOWsrc/postgres_mcp/index/dta_calc.py490CODE
LOWsrc/postgres_mcp/index/dta_calc.py534CODE
LOWsrc/postgres_mcp/index/dta_calc.py581CODE
LOWsrc/postgres_mcp/index/dta_calc.py671CODE
LOWsrc/postgres_mcp/index/dta_calc.py754CODE
LOWsrc/postgres_mcp/index/dta_calc.py775CODE
LOWsrc/postgres_mcp/index/index_opt_base.py180CODE
LOWsrc/postgres_mcp/index/llm_opt.py74CODE
LOWsrc/postgres_mcp/index/llm_opt.py293CODE
LOWsrc/postgres_mcp/database_health/index_health_calc.py22CODE
LOWsrc/postgres_mcp/sql/bind_params.py75CODE
LOWsrc/postgres_mcp/sql/bind_params.py115CODE
LOWsrc/postgres_mcp/sql/bind_params.py154CODE
LOWsrc/postgres_mcp/sql/bind_params.py175CODE
LOWsrc/postgres_mcp/sql/bind_params.py287CODE
LOWsrc/postgres_mcp/sql/bind_params.py413CODE
LOWsrc/postgres_mcp/sql/bind_params.py529CODE
LOWsrc/postgres_mcp/sql/bind_params.py552CODE
LOWsrc/postgres_mcp/sql/bind_params.py630CODE
LOWsrc/postgres_mcp/sql/extension_utils.py91CODE
LOWsrc/postgres_mcp/sql/sql_driver.py224CODE
LOWsrc/postgres_mcp/sql/safe_sql.py878CODE
LOWsrc/postgres_mcp/sql/safe_sql.py948CODE
Modern Structural Boilerplate23 hits · 23 pts
SeverityFileLineSnippetContext
LOWtests/utils.py12logger = logging.getLogger(__name__)CODE
LOWtests/unit/explain/test_explain_plan_real_db.py11logger = logging.getLogger(__name__)CODE
LOWtests/unit/database_health/test_database_health_tool.py8logger = logging.getLogger(__name__)CODE
LOWtests/integration/test_top_queries_integration.py10logger = logging.getLogger(__name__)CODE
LOWtests/integration/dta/test_dta_calc_integration.py14logger = logging.getLogger(__name__)CODE
LOWsrc/postgres_mcp/server.py46logger = logging.getLogger(__name__)CODE
LOWsrc/postgres_mcp/__init__.py20__all__ = [CODE
LOWsrc/postgres_mcp/top_queries/top_queries_calc.py13logger = logging.getLogger(__name__)CODE
LOWsrc/postgres_mcp/top_queries/__init__.py4__all__ = ["PG_STAT_STATEMENTS", "TopQueriesCalc"]CODE
LOWsrc/postgres_mcp/explain/explain_plan.py17logger = logging.getLogger(__name__)CODE
LOWsrc/postgres_mcp/explain/__init__.py5__all__ = [CODE
LOWsrc/postgres_mcp/index/dta_calc.py22logger = logging.getLogger(__name__)CODE
LOWsrc/postgres_mcp/index/dta_calc.py26logger = logging.getLogger(__name__)CODE
LOWsrc/postgres_mcp/index/index_opt_base.py23logger = logging.getLogger(__name__)CODE
LOWsrc/postgres_mcp/index/presentation.py18logger = logging.getLogger(__name__)CODE
LOWsrc/postgres_mcp/index/llm_opt.py21logger = logging.getLogger(__name__)CODE
LOWsrc/postgres_mcp/database_health/database_health.py19logger = logging.getLogger(__name__)CODE
LOWsrc/postgres_mcp/database_health/__init__.py4__all__ = ["DatabaseHealthTool", "HealthType"]CODE
LOWsrc/postgres_mcp/sql/bind_params.py21logger = logging.getLogger(__name__)CODE
LOWsrc/postgres_mcp/sql/__init__.py17__all__ = [CODE
LOWsrc/postgres_mcp/sql/extension_utils.py10logger = logging.getLogger(__name__)CODE
LOWsrc/postgres_mcp/sql/sql_driver.py17logger = logging.getLogger(__name__)CODE
LOWsrc/postgres_mcp/sql/safe_sql.py85logger = logging.getLogger(__name__)CODE
Unused Imports22 hits · 22 pts
SeverityFileLineSnippetContext
LOWsrc/postgres_mcp/__init__.py5CODE
LOWsrc/postgres_mcp/top_queries/__init__.py1CODE
LOWsrc/postgres_mcp/top_queries/__init__.py2CODE
LOWsrc/postgres_mcp/explain/explain_plan.py3CODE
LOWsrc/postgres_mcp/explain/__init__.py3CODE
LOWsrc/postgres_mcp/database_health/database_health.py1CODE
LOWsrc/postgres_mcp/database_health/__init__.py1CODE
LOWsrc/postgres_mcp/database_health/__init__.py2CODE
LOWsrc/postgres_mcp/sql/__init__.py3CODE
LOWsrc/postgres_mcp/sql/__init__.py4CODE
LOWsrc/postgres_mcp/sql/__init__.py5CODE
LOWsrc/postgres_mcp/sql/__init__.py6CODE
LOWsrc/postgres_mcp/sql/__init__.py7CODE
LOWsrc/postgres_mcp/sql/__init__.py8CODE
LOWsrc/postgres_mcp/sql/__init__.py9CODE
LOWsrc/postgres_mcp/sql/__init__.py10CODE
LOWsrc/postgres_mcp/sql/__init__.py11CODE
LOWsrc/postgres_mcp/sql/__init__.py12CODE
LOWsrc/postgres_mcp/sql/__init__.py13CODE
LOWsrc/postgres_mcp/sql/__init__.py14CODE
LOWsrc/postgres_mcp/sql/__init__.py15CODE
LOWsrc/postgres_mcp/sql/safe_sql.py1CODE
Empty Error Handlers3 hits · 15 pts
SeverityFileLineSnippetContext
HIGHtests/utils.py145except Exception:CODE
HIGHtests/unit/test_access_mode.py105except Exception:CODE
HIGHsrc/postgres_mcp/sql/sql_driver.py38except Exception:CODE
AI Slop Vocabulary5 hits · 8 pts
SeverityFileLineSnippetContext
MEDIUMtests/unit/index/test_dta_calc.py248 """Test the robust index comparison functionality."""STRING
MEDIUMsrc/postgres_mcp/index/llm_opt.py24# We introduce a Pydantic index class to facilitate communication with the LLMCOMMENT
MEDIUMsrc/postgres_mcp/database_health/replication_calc.py74 """Get comprehensive replication metrics."""STRING
LOWsrc/postgres_mcp/sql/bind_params.py454 # For non-numeric, just use most commonCOMMENT
LOWsrc/postgres_mcp/sql/bind_params.py458 # If adaptation fails, just use the valueCOMMENT
Over-Commented Block2 hits · 2 pts
SeverityFileLineSnippetContext
LOWdevenv.yaml21#imports:COMMENT
LOWsrc/postgres_mcp/index/dta_calc.py81COMMENT