Constructive
Organization@constructive-io
116
Published Tools
400
Total Stars
995,931
Weekly Downloads
11
GitHub Followers
76
Public Repos
100/100
Avg Security
Published Tools
2 MCP Servers93 Skills21 Agentsacross 7 categoriespyramation
Generate search conditions for your tsvector columns (PostGraphile v5)
pyramation
OpenAI (and OpenAI-compatible) adapter for agentic-kit
Constructive <[email protected]>
LLM integration plugin for PostGraphile v5 — server-side text-to-vector embedding and text companion fields for pgvector columns
...moreConstructive <[email protected]>
Standalone Express LLM service — agent threads, chat streaming, billing metering, and inference logging via express-context
...moreDan Lynch <[email protected]>
Shared protocol kernel (types, event stream, message + JSON helpers) for agentic-kit
Constructive <[email protected]>
LLM environment configuration — single source of truth for all LLM-related env vars and defaults
Constructive <[email protected]>
Registry-derived storage plane discovery for PostGraphile v5 — pairs @storageFiles/@storageBuckets codecs through their actual foreign-key relations and derives the canonical upload surface names, so no table name is ever load-bearing
...moreConstructive <[email protected]>
The run log as a browser reads it: a tenant-GraphQL RunLogStore over a module's agent_run/agent_event pair, plus the follower loop every run surface uses
...moreConstructive <[email protected]>
Tool approvals over the run log — the request, the human's answer and every settled gate decision are run-log entries, so desktop, cloud pi and agentic hosts ask and are answered on one surface
...morepyramation
Temporary package placeholder for staged publishing
pyramation
Portable JSON UI document format for Constructive Blocks: node types, runtime validation, and JSON Schema export
Dan Lynch <[email protected]>
Provider-agnostic LLM adapter with streaming and multi-turn support
Dan Lynch <[email protected]>
Minimal stateful agent runtime for agentic-kit
Dan Lynch <[email protected]>
Host-agnostic Constructive harness core — skill overlay resolution, materialization, and on-disk layout for harness hosts (desktop, CLI, MCP)
...moreDan Lynch <[email protected]>
Provider-agnostic LLM adapter with streaming and multi-turn support
Dan Lynch <[email protected]>
Pi adapter for agentic-kit — the Constructive typed db tools (provision, blueprint, codegen, records, policies, templates) and confirm gate as a pi coding-agent extension
...moreDan Lynch <[email protected]>
agent — the pi coding agent with the Constructive harness baked in, purely a shell
Constructive <[email protected]>
compose a pi coding-agent session with Constructive's run log, metering and approval lanes — one embedding for local and cloud runs
...moreConstructive <[email protected]>
The append-only agent run log — pi session entries stored verbatim under a run/seq wrapper, with projections for transcript, usage, tool state and resumable sessions
...moreConstructive <[email protected]>
pi extension that mirrors every session entry into an @agentic-kit/run-log store, verbatim and in order
Constructive <[email protected]>
harness-neutral metering for an agent run — the Constructive gateway as a model endpoint, run identity headers, and usage reporting
...moreConstructive <[email protected]>
harness-neutral Constructive database tools — provisioning, schema, policies, records, templates and codegen as HarnessTools any adapter can bind
...moreDan Lynch <[email protected]>
the DeepSeek Harness adapter for agentic-kit — Constructive's typed db tools and confirm gate as a dsh plugin, plus a dsh transcript reader for the run log
...moreConstructive <[email protected]>
The agent module's conversation as a library: thread load/create, an inbox over new messages, transcript append, ToolPart state machine and agent_task rows — over an injected GraphQL client.
...moreConstructive <[email protected]>
The host side of a headless agent run: a GateHost that asks for approval through the conversation thread, persona → model/prompt/tools selection, and an AgentEvent → transcript/task writer.
...morepyramation
Opt-in schema-scoped PostgreSQL introspection for Graphile
pyramation
PostgreSQL client utilities with query helpers, RLS context management, and database administration
pyramation
Unified PostGraphile v5 search plugin — abstracts tsvector, BM25, pg_trgm, and pgvector behind a single adapter-based architecture with composite searchScore
...morepyramation
PostGraphile v5 _meta introspection plugin — exposes a single _meta root query describing tables, fields, indexes, constraints, relations, inflection names, and smart-tag-derived metadata for dynamic query building and code generation
...morepyramation
PostgreSQL Package Manager - Database migration and package management CLI
pyramation
pgpm diff — identity-keyed semantic schema diff between pgpm modules, SQL dumps, and live databases
pyramation
PGPM module AST — plan/control/SQL-header parsers and the lossless module read/write layer
pyramation
Unified S3 utilities — client factory, file operations, presigned URLs
pyramation
supabase-test offers isolated, role-aware, and rollback-friendly PostgreSQL environments for integration tests with Supabase defaults baked in
...morepyramation
pgsql-test offers isolated, role-aware, and rollback-friendly PostgreSQL environments for integration tests — giving developers realistic test coverage without external state pollution
...morepyramation
PostgreSQL seeding utilities for CSV, JSON, and SQL data loading
pyramation
pgpm import — pgpm-itize arbitrary SQL dumps (pg_dump output, raw .sql) through the dials pipeline
pyramation
Vendor portability for pgpm — vendor shape profiles (supabase, insforge, ...) and pgsql-test seed adapters for deploying apply/transpile targets
...morepyramation
Wire protocol shared by the machine relay and the machine runner: the JSON frames a session is made of, and the codec that refuses malformed ones.
...morepyramation
Constructive SDK - Auto-generated GraphQL types and ORM client
pyramation
Constructive CLI SDK - Auto-generated GraphQL CLI with ORM client, context management, and interactive prompts
pyramation
Change-aware SQL transformation for PGPM — superset of @pgsql/transform plus change categorization, fixture closure, and bundle transpile/apply drivers
...morepyramation
Constructive React - Auto-generated React Query hooks and ORM client
pyramation
Drop-in replacement for pgsql-test that enables Drizzle ORM to work seamlessly with context management and RLS testing
pyramation
GraphQL SDK generator for Constructive databases with React Query hooks
pyramation
Realtime subscription plugin for PostGraphile v5 — per-table GraphQL subscriptions via LISTEN/NOTIFY
pyramation
Typed GraphQL ORM client for the Constructive Migrate API (db_migrate schema)
pyramation
Shared internals for Constructive PostGraphile v5 plugins - PgCondition query-builder walker and pg-resource introspection helpers
...morepyramation
PGPM migration bundle — the portable, content-addressed artifact layer (create/io/verify/transpile/diff/reconcile)
pyramation
Constructive environment configuration with GraphQL/Graphile support
pyramation
Constructive GraphQL/Graphile types for PostGraphile integration
pyramation
PostGraphile v5 plugin — exposes API-bound compute functions as typed GraphQL mutations backed by function_invocations inserts
...morepyramation
PostGraphile v5 ltree plugin — auto-detects ltree columns, exposes slash-path folder fields, and provides containment/glob filter operators
...morepyramation
Constructive GraphQL Testing with all plugins loaded
pyramation
Constructive GraphQL Server Testing with SuperTest HTTP requests
pyramation
Canonical Constructive error system: registry, codes, i18n messages, and cross-source (PostgreSQL/GraphQL/client) parsing. Zero runtime dependencies.
...morepyramation
Build GraphQL SDL from PostgreSQL databases using PostGraphile v5
pyramation
Constructive Playwright Testing with HTTP server support
pyramation
PostgreSQL seeding utilities with pgpm integration - batteries included
pyramation
Es6 class that generates ETag using the same algorithm as S3 via MD5 sum.
pyramation
PostGraphile v5 LRU cache with automatic pool cleanup integration
pyramation
PostGraphile v5 i18n plugin — language-aware fields from @i18n translation tables with Accept-Language negotiation and fallback chains
...morepyramation
Deploy a static build as an immutable Constructive release: hash, content-addressed upload with dedupe, one manifest commit, publish/rollback and preview refs
...morepyramation
Standardized project configuration loading — config files, rc files, presets, and layered merge with provenance
pyramation
List the files changed against a merge base, including working-tree and untracked changes
pyramation
CLI lifecycle utilities for building command-line applications
pyramation
Unified CLI for PostgreSQL AST parsing, deparsing, and code generation
pyramation
Combined SQL + PL/pgSQL parser with hydrated ASTs and transform API
pyramation
Source-level SQL/PL/pgSQL convention linter: fully-qualified references, no search_path, no dynamic SQL, with ESLint-style inline waivers. Pure AST, no database.
...morepyramation
AST-derived semantic facts for PostgreSQL statements: what each statement creates, references, and touches
pyramation
AST-based SQL transformation, qualification, classification and closure analysis for PostgreSQL
pyramation
Migration script generation for PostgreSQL — derive revert and verify scripts from classified statement facts