{"id":43664,"library":"postgres-graphql-data-service","title":"Postgres GraphQL Data Service","description":"An auto-generated GraphQL API layer for PostgreSQL databases that provides CRUD operations, aggregation queries, and transaction support without requiring schema definitions. Version 3.0.0 fixes SQL injection vulnerabilities. It is intended for quick prototyping or simple deployments, but lacks active maintenance, TypeScript types, and support for subscriptions or complex joins. The package is a standalone service (not a library) and requires manual setup via environment variables.","status":"active","version":"3.0.0","language":"javascript","source_language":"en","source_url":"https://github.com/rwagh/pgrm","tags":["javascript","nodejs","postgres","graphql","data","service"],"install":[{"cmd":"npm install postgres-graphql-data-service","lang":"bash","label":"npm"},{"cmd":"yarn add postgres-graphql-data-service","lang":"bash","label":"yarn"},{"cmd":"pnpm add postgres-graphql-data-service","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"PostgreSQL client for database connectivity","package":"pg","optional":false},{"reason":"GraphQL runtime for building the API","package":"graphql","optional":false}],"imports":[{"note":"This package is not a library; it is a standalone server. No import statements used.","symbol":"pgrm","correct":"Not importable as a library; run as a service via `npm start`"}],"quickstart":{"code":"# Clone and setup\nInstall packages: npm install\nConfigure .env: set PG_DB_HOST, PG_DB_PORT, PG_DB_USER, PG_DB_PASS, PG_DB_NAME\nStart service: npm start\nOpen GraphQL endpoint at http://localhost:80/graphql","lang":"javascript","description":"Shows how to set up and run the Postgres GraphQL Data Service locally."},"warnings":[{"fix":"Run using npm start or directly with node.","message":"The package is a service, not an importable library. Do not attempt to require or import it.","severity":"gotcha","affected_versions":">=3.0.0"},{"fix":"Use JavaScript only or create your own type definitions.","message":"No TypeScript support, types, or code completions provided.","severity":"gotcha","affected_versions":">=2.0.0"},{"fix":"Upgrade to version 3.0.0 or later.","message":"The README indicates SQL injection was fixed in version 3.0.0, implying previous versions may be vulnerable.","severity":"gotcha","affected_versions":"<3.0.0"},{"fix":"Set PORT environment variable to a value > 1024.","message":"Port 80 is default; on Unix systems without root, it may fail to bind. Use a higher port like 3000 in .env.","severity":"gotcha","affected_versions":">=1.0.0"}],"env_vars":null,"search_vec":"'3.0.0':29 'activ':45 'aggreg':19 'api':10 'auto':7 'auto-gener':6 'complex':54 'crud':17 'data':3,76 'databas':14 'definit':27 'deploy':42 'environ':70 'fix':30 'generat':8 'graphql':2,9,75 'inject':32 'intend':36 'javascript':72 'join':55 'lack':44 'layer':11 'librari':64 'mainten':46 'manual':67 'nodej':73 'oper':18 'packag':57 'postgr':1,74 'postgresql':13 'prototyp':39 'provid':16 'queri':20 'quick':38 'requir':25,66 'schema':26 'servic':4,61,77 'setup':68 'simpl':41 'sql':31 'standalon':60 'subscript':52 'support':23,50 'transact':22 'type':48 'typescript':47 'variabl':71 'version':28 'via':69 'vulner':33 'without':24","created_at":"2026-06-05T17:00:53.127328+00:00","updated_at":"2026-06-05T17:00:53.127328+00:00","problems":[{"fix":"Change PORT in .env to a value > 1024 (e.g., 3000).","cause":"Port 80 requires elevated privileges on Linux/macOS.","error":"Error: listen EACCES: permission denied 0.0.0.0:80"},{"fix":"Run npm install to install dependencies.","cause":"Missing PostgreSQL client dependency.","error":"Error: Cannot find module 'pg'"},{"fix":"Ensure PostgreSQL is running and check .env settings for host and port.","cause":"PostgreSQL server is not running or connection details are incorrect.","error":"Error: connect ECONNREFUSED 127.0.0.1:5432"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/rwagh/pgrm","github":"https://github.com/rwagh/pgrm","docs":null,"changelog":null,"pypi":null,"npm":"postgres-graphql-data-service","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}