REST API for any Postgres database
This report presents the forensic synthetic code analysis of PostgREST/postgrest, a Haskell project with 27,632 GitHub stars. SynthScan v2.0 examined 11,053 lines of code across 85 source files, recording 146 pattern matches distributed across 9 syntactic categories. The overall adjusted score of 15.1 places this repository in the Moderate AI signal band.
The scanner applied 160+ deterministic lexical heuristics, multi-line block detectors, abstract syntax tree depth profilers, and a cross-file Jaccard similarity matrix to construct a statistically normalised synthetic code estimate. All matches are individually weighted by severity coefficient and contextual multiplier before summation, and the resulting headline score is temporally discounted to account for the repository's development history relative to the commercial emergence of large language model coding tooling (November 2022 onward).
This chart maps the temporal evolution of the adjusted synthetic code score across successive scan runs. An upward trajectory indicates ongoing incorporation of AI-generated code or expanding LLM-assisted scaffolding; a stable or declining trajectory may reflect active human refactoring, code removal, or the adoption of stricter authorship policies. The dashed secondary line (right axis) independently tracks total raw pattern hit count, which can diverge from the normalised score when codebase size changes significantly between scans.
Classifies detected patterns by their diagnostic confidence and structural impact. CRITICAL patterns (coefficient 10) represent definitive synthetic signatures — hallucinated imports, explicit LLM attribution metadata — virtually never produced by human authors. HIGH (5) indicates strong structural tells such as cross-file repetition or cross-linguistic idioms. MEDIUM (2) covers recognisable conversational padding and AI-specific vocabulary. LOW (1) captures subtle indicators like tautological comments and generic boilerplate that require density to carry independent signal.
This horizontal bar chart decomposes the repository's raw synthetic code score by top-level directory, allowing you to pinpoint precisely which modules or components carry the highest AI authorship density. Directories with disproportionately high scores relative to their size warrant targeted manual review: concentrated AI signatures often trace back to mass-generated configuration layers, auto-ported test suites, LLM-scaffolded boilerplate classes, or entire subsystems authored under heavy copilot assistance. Use this view to prioritise your human code-review effort.
The scanner identified 146 distinct pattern matches across 9 syntactic categories. Each entry below represents a discrete location in the source code where the engine recorded a statistically significant AI authorship indicator. 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 diagnostic confidence level (CRITICAL / HIGH / MEDIUM / LOW). The Context column identifies whether the match occurred inside executable code, an inline comment, or a string literal — comment-context matches receive a ×1.5 weight because LLMs systematically over-annotate. The ⚡ bolt icon marks clustered matches: three or more patterns within a 10-line window, each receiving an additional ×1.5 density multiplier as dense clusters constitute far stronger evidence of synthetic authorship than isolated hits.
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | test/io/test_admin.py | 27 | def test_admin_ready_w_channel(defaultenv): | CODE |
| LOW | test/io/test_admin.py | 40 | def test_admin_ready_wo_channel(defaultenv): | CODE |
| LOW | test/io/test_admin.py | 53 | def test_admin_ready_includes_schema_cache_state(defaultenv, metapostgrest): | CODE |
| LOW | test/io/test_admin.py | 92 | def test_admin_ready_dependent_on_main_app(defaultenv): | CODE |
| LOW | test/io/test_admin.py | 110 | def test_admin_live_dependent_on_main_app(defaultenv): | CODE |
| LOW | test/io/test_admin.py | 121 | def test_admin_works_with_host_special_values(specialhostvalue, defaultenv): | CODE |
| LOW | test/io/test_admin.py | 147 | def test_admin_metrics_include_ghc_runtime_metrics(defaultenv): | CODE |
| LOW | test/io/test_admin.py | 161 | def test_admin_metrics_exclude_ghc_runtime_metrics_by_default(defaultenv): | CODE |
| LOW | test/io/test_admin.py | 171 | def test_admin_metrics_include_schema_cache_fails(defaultenv, metapostgrest): | CODE |
| LOW | test/io/config.py | 36 | def get_admin_host_and_port_from_config(config): | CODE |
| LOW | test/io/test_pg_internal.py | 5 | def test_listener_query_is_visible_in_pg_stat_activity(defaultenv): | CODE |
| LOW | test/io/util.py | 64 | def parse_server_timings_header(header): | CODE |
| LOW | test/io/test_connection.py | 23 | def test_fail_with_invalid_password(defaultenv): | CODE |
| LOW | test/io/test_connection.py | 45 | def test_get_pgrst_version_with_uri_connection_string(dburi_type, dburi, defaultenv): | CODE |
| LOW | test/io/test_connection.py | 67 | def test_get_pgrst_version_with_keyval_connection_string(defaultenv): | CODE |
| LOW | test/io/test_connection.py | 85 | def test_fail_with_invalid_dbname_and_automatic_recovery_disabled(defaultenv): | CODE |
| LOW | test/io/test_connection.py | 100 | def test_fail_with_automatic_recovery_disabled_and_terminated_using_query(defaultenv): | CODE |
| LOW | test/io/test_connection.py | 120 | def test_read_dburi_from_stdin_without_eol(dburi, defaultenv): | CODE |
| LOW | test/io/test_connection.py | 133 | def test_read_dburi_from_stdin_with_eol(dburi, defaultenv): | CODE |
| LOW | test/io/test_connection.py | 146 | def test_flush_pool_no_interrupt(defaultenv): | CODE |
| LOW | test/io/test_connection.py | 168 | def test_no_pool_connection_required_on_bad_http_logic(defaultenv): | CODE |
| LOW | test/io/test_connection.py | 183 | def test_no_pool_connection_required_on_options(defaultenv): | CODE |
| LOW | test/io/test_connection.py | 200 | def test_no_pool_connection_required_on_bad_jwt_claim(defaultenv): | CODE |
| LOW | test/io/test_connection.py | 213 | def test_no_pool_connection_required_on_bad_embedding(defaultenv): | CODE |
| LOW | test/io/test_connection.py | 223 | def test_pool_acquisition_timeout(level, defaultenv, metapostgrest): | CODE |
| LOW | test/io/test_connection.py | 254 | def test_pool_acquisition_timeout_logs_are_debounced(defaultenv): | CODE |
| LOW | test/io/test_connection.py | 302 | def test_positive_pool_metric(defaultenv): | CODE |
| LOW | test/io/test_zero_downtime.py | 11 | def test_so_reuseport_zero_downtime_handover(defaultenv): | CODE |
| LOW | test/io/test_big_schema.py | 11 | def test_schema_cache_load_max_duration(defaultenv): | CODE |
| LOW | test/io/test_big_schema.py | 46 | def test_openapi_in_big_schema(defaultenv): | CODE |
| LOW | test/io/test_big_schema.py | 61 | def test_stackoverflow_is_logged(level, defaultenv): | CODE |
| LOW | test/io/test_big_schema.py | 88 | def test_should_not_fail_with_stack_overflow(defaultenv): | CODE |
| LOW | test/io/test_big_schema.py | 105 | def test_second_request_for_non_existent_table_should_be_quick(defaultenv): | CODE |
| LOW | test/io/test_log.py | 201 | def test_log_lacks_role_with_empty_anon_role(defaultenv): | CODE |
| LOW | test/io/test_log.py | 223 | def test_log_postgrest_version(defaultenv): | CODE |
| LOW | test/io/test_log.py | 236 | def test_log_postgrest_host_and_port(host, defaultenv): | CODE |
| LOW | test/io/test_log.py | 264 | def test_log_postgrest_admin_server_host_and_port(host, defaultenv): | CODE |
| LOW | test/io/test_log.py | 295 | def test_log_error_when_schema_cache_load_error_on_startup_to_stderr(defaultenv): | CODE |
| LOW | test/io/test_log.py | 324 | def test_log_pool_req_observation(level, defaultenv): | CODE |
| LOW | test/io/test_log.py | 350 | def test_log_listener_connection_errors(defaultenv): | CODE |
| LOW | test/io/test_log.py | 368 | def test_log_listener_connection_start(defaultenv): | CODE |
| LOW | test/io/test_log.py | 388 | def test_db_error_logging_to_stderr(level, defaultenv, metapostgrest): | CODE |
| LOW | test/io/test_log.py | 425 | def test_schema_cache_query_sleep_logs(defaultenv): | CODE |
| LOW | test/io/test_log.py | 451 | def test_schema_cache_query_timings_log(level, defaultenv): | CODE |
| LOW | test/io/test_log.py | 474 | def test_empty_schema_cache_log_contains_jwt_role(defaultenv): | CODE |
| LOW | test/io/test_log.py | 501 | def test_expired_jwt_log_lacks_role(defaultenv): | CODE |
| LOW | test/io/test_log.py | 520 | def test_schema_cache_error_observation(defaultenv): | CODE |
| LOW | test/io/test_log.py | 540 | def test_invalid_rpc_method_log_contains_role(defaultenv): | CODE |
| LOW | test/io/test_log.py | 575 | def test_termination_unix_signal_logging(defaultenv): | CODE |
| LOW | test/io/test_log.py | 593 | def test_options_request_logs_but_cors_preflight_does_not(defaultenv): | CODE |
| LOW | test/io/test_graceful_shutdown.py | 7 | def test_graceful_shutdown_waits_for_in_flight_request(defaultenv): | CODE |
| LOW | test/io/test_reloading.py | 21 | def test_db_schema_notify_reload(defaultenv): | CODE |
| LOW | test/io/test_reloading.py | 73 | def test_invalid_role_claim_key_notify_reload(defaultenv): | CODE |
| LOW | test/io/test_reloading.py | 126 | def test_max_rows_notify_reload(defaultenv): | CODE |
| LOW | test/io/test_reloading.py | 157 | def test_no_double_schema_cache_reload_on_empty_schema(defaultenv): | CODE |
| LOW | test/io/test_reloading.py | 183 | def test_notify_reloading_catalog_cache(defaultenv): | CODE |
| LOW | test/io/test_reloading.py | 223 | def test_schema_cache_concurrent_notifications(slow_schema_cache_env): | CODE |
| LOW | test/io/test_reloading.py | 281 | def test_jwt_secret_external_file_reload(tmp_path, defaultenv): | CODE |
| LOW | test/io/test_reloading.py | 330 | def test_invalidate_jwt_cache_when_secret_changes(tmp_path, defaultenv): | CODE |
| LOW | test/io/test_reloading.py | 365 | def test_stale_schema_cache_dropped_table_returns_database_error(defaultenv): | CODE |
| 50 more matches not shown… | ||||
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | .stylish-haskell.yaml | 1 | # stylish-haskell configuration file | COMMENT |
| LOW | .stylish-haskell.yaml | 21 | - simple_align: | COMMENT |
| LOW | .stylish-haskell.yaml | 41 | # Default: global. | COMMENT |
| LOW | .stylish-haskell.yaml | 61 | # > import qualified Data.List as List | COMMENT |
| LOW | .stylish-haskell.yaml | 81 | # > init, last, length) | COMMENT |
| LOW | .stylish-haskell.yaml | 101 | # > , singleton | COMMENT |
| LOW | .stylish-haskell.yaml | 121 | COMMENT | |
| LOW | .stylish-haskell.yaml | 141 | # functions. | COMMENT |
| LOW | .stylish-haskell.yaml | 161 | # Default: false | COMMENT |
| LOW | .stylish-haskell.yaml | 181 | # | COMMENT |
| LOW | .stylish-haskell.yaml | 201 | # A common setting is the number of columns (parts of) code will be wrapped | COMMENT |
| LOW | test/io/test_zero_downtime.py | 21 | failures = [] | COMMENT |
| LOW | docs/conf.py | 1 | # -*- coding: utf-8 -*- | COMMENT |
| LOW | docs/conf.py | 61 | # The language for content autogenerated by Sphinx. Refer to documentation | COMMENT |
| LOW | docs/conf.py | 81 | # default_role = None | COMMENT |
| LOW | docs/conf.py | 121 | # The name for this set of Sphinx documents. | COMMENT |
| LOW | docs/conf.py | 141 | COMMENT | |
| LOW | docs/conf.py | 161 | # html_additional_pages = {} | COMMENT |
| LOW | docs/conf.py | 181 | # If true, an OpenSearch description file will be output, and all pages will | COMMENT |
| LOW | docs/conf.py | 201 | # implements a search results scorer. If empty, the default will be used. | COMMENT |
| LOW | docs/conf.py | 221 | # (source start file, target name, title, | COMMENT |
| LOW | docs/conf.py | 241 | # Documents to append as an appendix to all manuals. | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| HIGH | test/io/test_log.py | 318 | log_err_message = '{"code":"PGRST002","details":null,"hint":null,"message":"Could not query the database for the | CODE |
| HIGH | test/io/test_log.py | 570 | log_message = '{"code":"PGRST001","details":"no connection to the server\\n","hint":null,"message":"Database cli | CODE |
| HIGH⚡ | test/io/test_settings.py | 299 | == '{"code":"57014","details":null,"hint":null,"message":"canceling statement due to statement timeout"}' | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | test/io/util.py | 18 | except Exception as e: | CODE |
| MEDIUM | test/io/util.py | 15 | def run(self): | CODE |
| LOW | test/io/test_zero_downtime.py | 49 | except Exception as exc: | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | .stylish-haskell.yaml | 2 | # ================================== | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | docs/conf.py | 6 | # This file is execfile()d with the current directory set to its | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | test/io/test_log.py | 28 | CODE | |
| LOW | test/io/test_log.py | 91 | CODE | |
| LOW | test/io/postgrest.py | 92 | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | test/load/put.json | 3 | "name": "John Doe", | CODE |
| LOW | test/load/fixtures.sql | 16 | INSERT INTO test.actors VALUES (1, 'John Doe'); | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | test/io/postgrest.py | 92 | CODE |