Title: pgsql-parser — PostgreSQL SQL Conversion Engine
Open Graph Title: pgsql-parser — PostgreSQL SQL Conversion Engine
Description: The real PostgreSQL parser for Node.js that interprets and converts PostgreSQL syntax. Uses actual PostgreSQL C parser via WebAssembly for symmetric parsing and deparsing with battle-tested reliability.
Open Graph Description: The real PostgreSQL parser for Node.js that interprets and converts PostgreSQL syntax. Uses actual PostgreSQL C parser via WebAssembly for symmetric parsing and deparsing with battle-tested reliability.
Opengraph URL: https://constructive.io/stack/pgsql-parser
Domain: constructive.io
{
"@context": "https://schema.org",
"@graph": [
{
"@type": "SoftwareApplication",
"@id": "software:pgsql-parser",
"name": "PgSQL Parser",
"description": "The definitive PostgreSQL parser for JavaScript and TypeScript, delivering byte-for-byte SQL round-tripping with AST-level precision.",
"url": "https://github.com/constructive-io/pgsql-parser",
"codeRepository": "https://github.com/constructive-io/pgsql-parser",
"sameAs": [
"https://www.npmjs.com/package/pgsql-parser"
],
"programmingLanguage": "TypeScript",
"creator": [
{
"@id": "org:constructive"
}
],
"contributor": {
"@id": "person:danlynch"
},
"applicationCategory": [
"database",
"postgres",
"ast"
],
"softwareRequirements": {
"@id": "software:pgsql-deparser"
},
"isBasedOn": {
"@id": "software:postgresql"
}
},
{
"@id": "org:constructive",
"@type": "Organization",
"name": "Constructive",
"alternateName": "Interweb, Inc.",
"url": "https://constructive.io",
"x-logo": "/logos/constructive.svg",
"keywords": [
"founded"
],
"logo": "https://constructive.io/logo.svg",
"founder": [
{
"@id": "person:danlynch"
}
],
"subjectOf": [
{
"@id": "article:interweb-rebrands-as-constructive"
},
{
"@id": "article:constructive-investorhangout"
},
{
"@id": "article:constructives-pgpm-innovating-postgresql-investorhangout"
},
{
"@id": "article:constructive-launches-pgpm-pr-newswire"
},
{
"@id": "article:constructive-launches-pgpm-yahoo"
},
{
"@id": "article:introducing-pgpm-postgresql-org"
}
]
},
{
"@id": "person:danlynch",
"@type": "Person",
"name": "Dan Lynch",
"alternateName": [
"Dan Lynch",
"Daniel Lynch",
"pyramation"
],
"url": "https://www.danlynch.com",
"sameAs": [
"https://www.npmjs.com/~pyramation",
"https://www.youtube.com/@pyramation",
"https://scholar.google.com/citations?user=1U4vfEUAAAAJ&hl=en",
"https://berkeley.academia.edu/DanLynch",
"https://github.com/pyramation",
"https://www.linkedin.com/in/dan-p-lynch/",
"https://www.crunchbase.com/person/dan-lynch-3",
"https://x.com/danlynch",
"https://www.instagram.com/pyramation/",
"https://www.facebook.com/danlynch"
],
"image": "https://avatars.githubusercontent.com/u/545047?v=4",
"jobTitle": "Founder & CEO",
"worksFor": {
"@id": "org:constructive"
},
"description": "Dan Lynch is a serial entrepreneur and founder of Constructive, with multiple successful exits including Brandcast and Amaze/Famo.us. He holds two EECS degrees from UC Berkeley and has built platforms powering billions in blockchain and cloud transactions."
},
{
"@type": "SoftwareApplication",
"@id": "software:pgsql-deparser",
"name": "PgSQL Deparser",
"description": "The definitive Postgres deparser for JavaScript and TypeScript, delivering byte-for-byte SQL round-tripping with AST-level precision.",
"url": "https://github.com/constructive-io/pgsql-parser",
"codeRepository": "https://github.com/constructive-io/pgsql-parser",
"sameAs": [
"https://www.npmjs.com/package/pgsql-deparser"
],
"programmingLanguage": "TypeScript",
"creator": [
{
"@id": "org:constructive"
}
],
"contributor": {
"@id": "person:danlynch"
},
"applicationCategory": [
"database",
"postgres",
"ast"
]
},
{
"@type": "SoftwareSourceCode",
"@id": "software:postgresql",
"name": "PostgreSQL",
"url": "https://www.postgresql.org/",
"codeRepository": "https://github.com/postgres/postgres",
"programmingLanguage": "C",
"applicationCategory": [
"database",
"postgres"
],
"creator": {
"@id": "org:postgres"
},
"license": "https://opensource.org/licenses/PostgreSQL"
},
{
"@type": "Article",
"@id": "article:interweb-rebrands-as-constructive",
"headline": "Interweb, Inc. Rebrands as Constructive™ -- A Unified, Modular, and Secure Postgres Platform for Production-Grade Applications",
"url": "https://www.prnewswire.com/news-releases/interweb-inc-rebrands-as-constructive--a-unified-modular-and-secure-postgres-platform-for-production-grade-applications-302638777.html",
"publisher": {
"@id": "org:pr-newswire"
},
"datePublished": "2025-12-11",
"about": [
{
"@id": "org:constructive"
},
{
"@id": "org:launchql"
},
{
"@id": "org:hyperweb"
}
],
"mentions": [
{
"@id": "org:constructive"
},
{
"@id": "org:launchql"
},
{
"@id": "org:hyperweb"
},
{
"@id": "person:danlynch"
},
{
"@id": "org:supabase"
},
{
"@id": "person:paul-copplestone"
}
],
"image": [
{
"@id": "image:constructive-pr-newswire"
}
]
},
{
"@type": "Article",
"@id": "article:constructive-investorhangout",
"headline": "Constructive™: The Comprehensive Postgres Platform for Development",
"url": "https://investorshangout.com/constructive-the-comprehensive-postgres-platform-for-development-485840-/",
"publisher": {
"@id": "org:investor-hangout"
},
"datePublished": "2025-12-11",
"author": {
"@type": "Person",
"name": "Thomas Cooper"
},
"about": [
{
"@id": "org:constructive"
}
],
"mentions": [
{
"@id": "org:constructive"
},
{
"@id": "person:danlynch"
}
]
},
{
"@type": "Article",
"@id": "article:constructives-pgpm-innovating-postgresql-investorhangout",
"headline": "Constructive's pgpm: Innovating PostgreSQL for Developers",
"url": "https://investorshangout.com/constructives-pgpm-innovating-postgresql-for-developers-490322-/",
"datePublished": "2025-12-17",
"author": {
"@type": "Person",
"name": "Dominic Sanders"
},
"publisher": {
"@id": "org:investor-hangout"
},
"about": [
{
"@id": "org:constructive"
},
{
"@id": "software:pgpm"
}
],
"mentions": [
{
"@id": "org:constructive"
},
{
"@id": "software:pgpm"
},
{
"@id": "person:danlynch"
}
]
},
{
"@type": "NewsArticle",
"@id": "article:constructive-launches-pgpm-pr-newswire",
"headline": "Constructive Launches pgpm: Modular Postgres for Large-Scale Application Development",
"url": "https://www.prnewswire.com/news-releases/constructive-launches-pgpm-modular-postgres-for-large-scale-application-development-302644203.html",
"datePublished": "2025-12-17",
"publisher": {
"@id": "org:pr-newswire"
},
"about": [
{
"@id": "org:constructive"
},
{
"@id": "software:pgpm"
}
],
"mentions": [
{
"@id": "org:constructive"
},
{
"@id": "software:pgpm"
},
{
"@id": "person:danlynch"
},
{
"@id": "person:kemnitz"
},
{
"@id": "person:stonebraker"
}
]
},
{
"@type": "NewsArticle",
"@id": "article:constructive-launches-pgpm-yahoo",
"headline": "Constructive Launches pgpm: Modular Postgres for Large-Scale Application Development",
"url": "https://finance.yahoo.com/news/constructive-launches-pgpm-modular-postgres-131400906.html",
"datePublished": "2025-12-17",
"publisher": {
"@id": "org:yahoo"
},
"about": [
{
"@id": "org:constructive"
},
{
"@id": "software:pgpm"
}
],
"mentions": [
{
"@id": "org:constructive"
},
{
"@id": "software:pgpm"
},
{
"@id": "person:danlynch"
},
{
"@id": "person:kemnitz"
},
{
"@id": "person:stonebraker"
}
]
},
{
"@type": "NewsArticle",
"@id": "article:introducing-pgpm-postgresql-org",
"headline": "Introducing pgpm: A Package Manager for Modular PostgreSQL",
"url": "https://www.postgresql.org/about/news/introducing-pgpm-a-package-manager-for-modular-postgresql-3196/",
"datePublished": "2026-01-07",
"publisher": {
"@id": "org:postgresql"
},
"author": {
"@id": "org:constructive"
},
"about": [
{
"@id": "software:pgpm"
},
{
"@id": "org:constructive"
}
],
"mentions": [
{
"@id": "software:pgpm"
},
{
"@id": "org:constructive"
},
{
"@id": "person:danlynch"
},
{
"@id": "person:kemnitz"
}
]
},
{
"@type": "Organization",
"@id": "org:postgres",
"name": "PostgreSQL Global Development Group",
"alternateName": "Postgres",
"url": "https://www.postgresql.org/",
"logo": "https://constructive.io/logos/postgres.svg",
"sameAs": [
"https://github.com/postgres",
"https://en.wikipedia.org/wiki/PostgreSQL",
"https://x.com/PostgreSQL"
],
"x-logo": "/logos/postgres.svg",
"x-logoWidth": 60
},
{
"@type": "Organization",
"@id": "org:pr-newswire",
"name": "PR Newswire",
"url": "https://www.prnewswire.com/",
"keywords": [
"press"
]
},
{
"@type": "Organization",
"@id": "org:launchql",
"name": "LaunchQL",
"description": "Former product brand for Postgres developer tools, now consolidated under Constructive.",
"url": "https://launchql.com",
"keywords": [
"founded",
"deprecated"
],
"parentOrganization": {
"@id": "org:constructive"
}
},
{
"@type": "Organization",
"@id": "org:hyperweb",
"name": "Hyperweb",
"description": "Web3 developer tools and infrastructure.",
"url": "https://hyperweb.io",
"keywords": [
"founded"
],
"parentOrganization": {
"@id": "org:constructive"
}
},
{
"@type": "Organization",
"@id": "org:supabase",
"name": "Supabase",
"url": "https://supabase.com/",
"logo": "https://constructive.io/logos/supabase.svg",
"x-logo": "/logos/supabase.svg",
"x-logoWidth": 140,
"keywords": [
"advised",
"served",
"logo-cloud"
],
"x-priority": 18,
"sameAs": [
"https://github.com/supabase",
"https://x.com/supabase"
],
"memberOf": {
"@id": "org:postgres"
},
"usesSoftware": [
{
"@id": "software:constructive"
},
{
"@id": "software:pgsql-parser"
}
]
},
{
"@type": "Person",
"@id": "person:paul-copplestone",
"name": "Paul Copplestone",
"affiliation": {
"@id": "org:supabase"
},
"sameAs": [
"https://twitter.com/kiwicopple",
"https://github.com/kiwicopple"
]
},
{
"@type": "ImageObject",
"@id": "image:constructive-pr-newswire",
"name": "Constructive PR Newswire Announcement",
"caption": "Interweb, Inc. Rebrands as Constructive™ — A Unified, Modular, and Secure Postgres Platform for Production-Grade Applications",
"associatedOrganization": "org:constructive",
"keywords": [
"startup",
"constructive",
"rebrand",
"press-release",
"pr-newswire"
],
"contentUrl": "https://constructive.io/timeline/startups/constructive/pr-newswire.jpg"
},
{
"@type": "Organization",
"@id": "org:investor-hangout",
"name": "Investors Hangout",
"url": "https://investorshangout.com/",
"keywords": [
"press"
]
},
{
"@type": "SoftwareApplication",
"@id": "software:pgpm",
"name": "pgpm",
"description": "Modern package manager for Postgres extensions with dependency resolution and version management.",
"url": "https://github.com/constructive-io/constructive",
"codeRepository": "https://github.com/constructive-io/constructive",
"sameAs": [
"https://www.npmjs.com/package/pgpm",
"https://pgpm.io"
],
"subjectOf": [
{
"@id": "website:pgpm.io"
},
{
"@id": "article:introducing-pgpm-postgresql-org"
}
],
"programmingLanguage": "TypeScript",
"creator": [
{
"@id": "org:constructive"
}
],
"contributor": [
{
"@id": "person:danlynch"
}
],
"applicationCategory": [
"database",
"package-manager",
"devops"
]
},
{
"@type": "Person",
"@id": "person:kemnitz",
"name": "Greg Kemnitz",
"jobTitle": "Co-founder",
"affiliation": {
"@id": "org:wirekite"
},
"sameAs": [
"https://www.linkedin.com/in/greg-kemnitz-aba9151/"
],
"worksFor": [
{
"@type": "Role",
"roleName": "Chief Programmer",
"startDate": "1989-05",
"endDate": "1991-12",
"worksFor": {
"@id": "org:postgres-project-berkeley"
}
}
]
},
{
"@type": "Person",
"@id": "person:stonebraker",
"name": "Michael Stonebraker",
"jobTitle": "Professor",
"affiliation": {
"@id": "school:berkeley"
},
"sameAs": [
"https://en.wikipedia.org/wiki/Michael_Stonebraker"
],
"award": [
"Turing Award (2014)"
],
"description": "Computer scientist, creator of Postgres, and Turing Award winner."
},
{
"@type": "Organization",
"@id": "org:yahoo",
"name": "Yahoo Finance",
"url": "https://finance.yahoo.com/",
"keywords": [
"press"
]
},
{
"@type": "WebSite",
"@id": "website:pgpm.io",
"url": "https://pgpm.io",
"name": "pgpm",
"description": "A Postgres Package Manager",
"mainEntity": {
"@id": "software:pgpm"
},
"publisher": {
"@id": "org:constructive"
}
},
{
"@type": "Organization",
"@id": "org:wirekite",
"name": "Wirekite",
"url": "https://wirekite.io",
"founder": [
{
"@id": "person:kemnitz"
}
]
},
{
"@type": "Organization",
"@id": "org:postgres-project-berkeley",
"name": "Postgres Project",
"description": "The original Postgres research project at UC Berkeley (1986-1994), led by Michael Stonebraker, which became the foundation for PostgreSQL.",
"parentOrganization": {
"@id": "school:berkeley"
},
"founder": [
{
"@id": "person:stonebraker"
}
],
"member": [
{
"@id": "person:stonebraker"
},
{
"@id": "person:kemnitz"
}
],
"foundingDate": "1986",
"dissolutionDate": "1994",
"sameAs": [
"https://en.wikipedia.org/wiki/PostgreSQL#History"
]
},
{
"@type": "CollegeOrUniversity",
"@id": "school:berkeley",
"name": "University of California, Berkeley",
"url": "https://www.berkeley.edu",
"keywords": [
"studied"
],
"alumni": [
{
"@id": "person:danlynch"
}
],
"x-priority": 12
},
{
"@type": "Organization",
"@id": "org:gel",
"name": "Gel Data",
"alternateName": [
"EdgeDB",
"Gel"
],
"url": "https://gel.io/",
"logo": "https://constructive.io/logos/gel.svg",
"x-logo": "/logos/gel.svg",
"x-logoWidth": 45,
"keywords": [
"served",
"logo-cloud"
],
"x-priority": 50,
"sameAs": [
"https://github.com/geldata",
"https://x.com/geldata"
],
"parentOrganization": {
"@id": "org:vercel"
},
"memberOf": {
"@id": "org:postgres"
},
"usesSoftware": [
{
"@id": "software:constructive"
},
{
"@id": "software:pgsql-parser"
}
]
},
{
"@type": "Organization",
"@id": "org:neon",
"name": "Neon DB",
"alternateName": [
"Neon"
],
"url": "https://neon.tech/",
"logo": "https://constructive.io/logos/neon.svg",
"x-logo": "/logos/neon.svg",
"x-logoWidth": 100,
"keywords": [
"served",
"logo-cloud"
],
"x-priority": 21,
"sameAs": [
"https://github.com/neondatabase",
"https://x.com/neondatabase"
],
"parentOrganization": {
"@id": "org:databricks"
},
"memberOf": {
"@id": "org:postgres"
},
"usesSoftware": [
{
"@id": "software:constructive"
},
{
"@id": "software:pgsql-parser"
}
]
},
{
"@type": "Organization",
"@id": "org:databricks",
"name": "Databricks",
"url": "https://databricks.com/",
"logo": "https://constructive.io/logos/databricks.svg",
"x-logo": "/logos/databricks.svg",
"x-logoWidth": 130,
"keywords": [
"served",
"logo-cloud"
],
"x-priority": 22,
"sameAs": [
"https://github.com/databricks",
"https://x.com/databricks"
],
"subOrganization": [
{
"@id": "org:neon"
}
],
"usesSoftware": [
{
"@id": "software:constructive"
},
{
"@id": "software:pgsql-parser"
}
]
},
{
"@type": "Organization",
"@id": "org:iasql",
"name": "IaSQL",
"description": "Infrastructure as SQL - manage cloud infrastructure using PostgreSQL.",
"url": "https://iasql.com/",
"logo": "https://constructive.io/logos/iasql.png",
"x-logo": "/logos/iasql.png",
"x-logoWidth": 90,
"keywords": [
"served",
"logo-cloud"
],
"sameAs": [
"https://github.com/iasql"
],
"memberOf": {
"@id": "org:postgres"
},
"usesSoftware": [
{
"@id": "software:constructive"
},
{
"@id": "software:pgsql-parser"
}
]
},
{
"@type": "Organization",
"@id": "org:charles-ai",
"name": "Charles AI",
"url": "https://charles.ai/",
"logo": "https://constructive.io/logos/charles-ai.svg",
"x-logo": "/logos/charles-ai.svg",
"x-logoWidth": 120,
"keywords": [
"served",
"logo-cloud"
],
"usesSoftware": [
{
"@id": "software:constructive"
},
{
"@id": "software:pgsql-parser"
}
]
},
{
"@type": "Organization",
"@id": "org:seam",
"name": "Seam",
"description": "API for controlling IoT devices like smart locks and thermostats.",
"url": "https://seam.co/",
"logo": "https://constructive.io/logos/seam.svg",
"x-logo": "/logos/seam.svg",
"x-logoWidth": 100,
"keywords": [
"served",
"logo-cloud"
],
"sameAs": [
"https://github.com/seamapi"
],
"usesSoftware": [
{
"@id": "software:constructive"
},
{
"@id": "software:pgsql-parser"
}
]
},
{
"@type": "Organization",
"@id": "org:change-engine",
"name": "Change Engine",
"url": "https://changeengine.com/",
"logo": "https://constructive.io/logos/change-engine.png",
"x-logo": "/logos/change-engine.png",
"x-logoWidth": 160,
"keywords": [
"served",
"logo-cloud"
],
"usesSoftware": [
{
"@id": "software:constructive"
},
{
"@id": "software:pgsql-parser"
}
]
},
{
"@type": "Organization",
"@id": "org:ashby",
"name": "Ashby",
"description": "All-in-one recruiting platform for ambitious teams.",
"url": "https://www.ashbyhq.com/",
"logo": "https://constructive.io/logos/ashby.svg",
"x-logo": "/logos/ashby.svg",
"x-logoWidth": 90,
"keywords": [
"contributor",
"served",
"logo-cloud"
],
"x-priority": 23,
"sameAs": [
"https://github.com/ashbyhq",
"https://x.com/ashaborhq"
],
"usesSoftware": [
{
"@id": "software:constructive"
},
{
"@id": "software:pgsql-parser"
}
]
}
]
}| fb:app_id | 2046496336173104 |
| og:image:width | 1200 |
| og:image:height | 713 |
| twitter:creator | @constructive_io |
| og:type | website |
| og:image | https://constructive.io/og_image/pgsql-parser.png |
| og:image:alt | pgsql-parser |
| og:site_name | Constructive - Secure, Modular Postgres for the AI Era |
| theme-color | #1F9CFF |
Links:
Viewport: width=device-width, initial-scale=1
Robots: index,follow