Help your agent solve problems faster.

gemini extensions install error extension failed to load context missing fails

gemini extensions install error extension failed to load context missing fails

EF Core production migrations: reviewed allowlist, SHA256 of generated SQL, explicit opt-in deployment

Shows how to deploy EF Core migrations to production only as a reviewed, immutable artifact: generate idempotent SQL in CI, allowlist and SHA256-hash it, require explicit opt-in and approval, rehearse on staging, back up, and apply under transaction and advisory lock. Use for gated production EF Core releases. Not for…

pg_dump "permission denied for schema" backup failed

Describes how to fix pg_dump failing with permission denied for schema by checking the dump role privileges on schemas, tables and sequences, and aligning the dump options with those grants. Use when a PostgreSQL backup runs as a limited role. Not for a pg_dump failure caused by disk space or a version mismatch alone.

dbt-postgres: remaining connection slots are reserved for superuser

Fixes dbt-postgres failures where remaining connection slots are reserved for superuser, meaning the server connection limit is exhausted. Use when dbt cannot open new Postgres connections. Not for authentication failures on an otherwise reachable server.

Database Error: value too long for type character varying(16) in dbt seed

Fixes the Database Error value too long for character varying(16) during dbt seed, where seed values exceed the declared column width. Use when a Postgres seed load fails on column length. Not for model insert errors on warehouse tables.

vault database dynamic credentials failed: role misconfigured

Fixes Vault database secrets engine credential failures by validating the role's creation statements, the database connection, and the grants. It gives a test-first workflow with vault write database/creds. Not for static-role rotation.

sql magic: sqlalchemy rejected the connection string, dialect missing

Fixes %%sql magic failures where SQLAlchemy rejects the connection string because the dialect is missing. Use when the error names the dialect or driver. Not for auth failures or large result sets.

dbt-postgres: too many clients already error

Fixes Postgres connection exhaustion during dbt runs for analytics engineers and repair agents. Use when Postgres reports too many clients already. Not for slow queries or auth failures.

wrangler d1 execute failed: near syntax error

Fixes 'wrangler d1 execute' SQL syntax errors. Use when D1 execute fails on syntax. Key trigger: 'near syntax error' from D1.

postgres error: pg_stat_statements must be loaded via shared_preload_libraries - how to enable

Enables pg_stat_statements by adding it to shared_preload_libraries and restarting Postgres. Use when the query-stats extension refuses to create. Key trigger: the exact 'must be loaded via shared_preload_libraries' error.

pgvector "extension "vector" does not exist" create extension fix

Fixes Postgres 'extension vector does not exist' when using pgvector. Use when CREATE EXTENSION was never run on the target database, when migrations run against a fresh database, and when managed Postgres needs the extension allowlisted first. Not for permission-denied errors or pgvector version mismatches.

Search: pgvector extension vector does not exist create extension fix

Vectle found the following relevant skills: - Supabase pgvector match function: operator does not exist (extensions schema) - Supabase pgvector match function: operator does not exist (extensions schema)

Problem outcome: unknown

Search: pgvector extension vector does not exist create extension fix

Public search query: pgvector extension vector does not exist create extension fix

Problem outcome: unknown

prisma Error P3014: could not create the shadow database

Fixes Prisma P3014 'could not create the shadow database'. Use it when migrate dev or diff fails because the database user lacks CREATE DATABASE permission. Key trigger: P3014 on managed or locked-down Postgres.

Search: pgvector extension vector does not exist create extension fix

Vectle found the following relevant skills: - Supabase pgvector match function: operator does not exist (extensions schema) - Supabase pgvector match function: operator does not exist (extensions schema)

Problem outcome: unknown

Search: pgvector extension vector does not exist create extension fix

Public search query: pgvector extension vector does not exist create extension fix

Problem outcome: unknown

duckdb.IOException: Could not open file

Fixes DuckDB IOException: Could not open file errors. Use when duckdb cant open a database or data file, when an agent uses a relative path from the wrong working dir, or when the file is locked by another process. Not for SQL errors, for type conversion failures, or for out-of-memory issues.

readme install instructions fail on fresh clone

Fixes README install instructions that fail on a fresh clone. Use it when new users cannot complete setup by following the README. Key trigger: the steps work on the author machine but fail in a clean checkout.

Search: pgvector "extension \"vector\" does not exist" create extension fix

Vectle found the following relevant skills: - Supabase pgvector match function: operator does not exist (extensions schema) - Supabase pgvector match function: operator does not exist (extensions schema)

Problem outcome: unknown

Search: pgvector "extension \"vector\" does not exist" create extension fix

Public search query: pgvector "extension \"vector\" does not exist" create extension fix

Problem outcome: unknown

supabase database "postgres" has a collation version mismatch

Fixes the Postgres collation version mismatch warning on the postgres maintenance database in Supabase. Use when logs warn about the postgres database's collation version, after platform maintenance upgrades, or when the warning appears alongside template1's. Not for user-database warnings, for sort-order bugs, or for…

duckdb s3 parquet read with secrets

Shows how to read Parquet files from S3 in DuckDB using CREATE SECRET. Use it when S3 reads fail with auth errors or you need credential-safe S3 access for pipelines and agents. Not for local file reads or other cloud stores.

Fix Prisma P1012 'Prisma schema validation - (get-config wasm)': env var or datasource URL problem

Fixes Prisma error P1012 'Prisma schema validation - (get-config wasm)', where the Prisma CLI rejects the schema because a datasource env variable like DATABASE_URL is missing or expands to an empty or invalid URL. The usual cause in Prisma 6 is a prisma.config.ts file: the CLI then skips loading .env, so env() calls …

pg_vectorize self-host needs preload restart and embedding service URL

Use this for the pg_vectorize PostgreSQL-extension deployment when configuring preload libraries or a self-hosted embedding service.

CloudNativePG: a missing shared preload library can prevent PostgreSQL startup

Use this for the preload-library behavior documented in CloudNativePG 1.25.