{"id":26726,"library":"apache-airflow-providers-pgvector","title":"Apache Airflow Provider for pgvector","description":"An Apache Airflow provider package that integrates pgvector, enabling vector similarity search operations in Airflow via hooks and operators. Current version is 1.7.1, released under the Airflow provider maintenance cadence.","status":"active","version":"1.7.1","language":"python","source_language":"en","source_url":"https://github.com/apache/airflow/tree/main/airflow/providers/pgvector","tags":["airflow","provider","pgvector","vector-database"],"install":[{"cmd":"pip install apache-airflow-providers-pgvector","lang":"bash","label":"Standard install"},{"cmd":"pip install apache-airflow[pgvector]","lang":"bash","label":"Install via Airflow extras"}],"dependencies":[{"reason":"Core Airflow dependency; provider requires Airflow 2.6+","package":"apache-airflow","optional":false},{"reason":"Required for pgvector functionality","package":"pgvector","optional":false}],"imports":[{"note":"Correct import path as of provider version 1.0+","symbol":"PgvectorHook","correct":"from airflow.providers.pgvector.hooks.pgvector import PgvectorHook"},{"note":"Correct operator import","symbol":"PgvectorOperator","correct":"from airflow.providers.pgvector.operators.pgvector import PgvectorOperator"}],"quickstart":{"code":"from airflow import DAG\nfrom datetime import datetime\nfrom airflow.providers.pgvector.operators.pgvector import PgvectorOperator\n\nwith DAG(\n    dag_id='pgvector_demo',\n    start_date=datetime(2024, 1, 1),\n    schedule=None,\n    catchup=False\n) as dag:\n    create_table = PgvectorOperator(\n        task_id='create_hnsw_index',\n        sql=\"CREATE TABLE IF NOT EXISTS items (id bigserial PRIMARY KEY, embedding vector(3))\"\n    )\n    insert = PgvectorOperator(\n        task_id='insert_vector',\n        sql=\"INSERT INTO items (embedding) VALUES ('[1,2,3]'::vector)\"\n    )\n    create_table >> insert","lang":"python","description":"Minimal DAG using PgvectorOperator to create a table with vector column and insert data."},"warnings":[{"fix":"Update imports to use the new paths as shown in the imports section.","message":"In provider version 1.0.0, the import paths changed from 'airflow.providers.pgvector.hooks.pgvector_hook' to 'airflow.providers.pgvector.hooks.pgvector' and operators similarly.","severity":"breaking","affected_versions":"<1.0.0"},{"fix":"Ensure your PostgreSQL instance has the pgvector extension installed (e.g., CREATE EXTENSION vector;).","message":"The provider requires the pgvector extension to be installed in PostgreSQL; simply installing the Python package is insufficient.","severity":"gotcha","affected_versions":"all"},{"fix":"Set up a Postgres connection in Airflow (conn_type='postgres') and in extras provide e.g., {\"pgvector\": true}. Ensure host, schema, login, password are correct.","message":"Connection configuration: the hook expects an Airflow connection with conn_type='postgres' and extra containing pgvector-specific parameters. Using wrong conn_type or missing extras will cause connection failures.","severity":"gotcha","affected_versions":"all"}],"env_vars":null,"last_verified":"2026-05-01T00:00:00.000Z","next_check":"2026-07-30T00:00:00.000Z","problems":[{"fix":"Change the connection's conn_type to 'postgres' (or 'postgresql') and set the host/port/database accordingly.","cause":"Using conn_type='pgvector' instead of 'postgres' for the Airflow connection.","error":"airflow.exceptions.AirflowException: The conn_type `pgvector` is not supported"},{"fix":"Update import to: from airflow.providers.pgvector.hooks.pgvector import PgvectorHook","cause":"Importing from the old module path used in provider versions before 1.0.0.","error":"ModuleNotFoundError: No module named 'airflow.providers.pgvector.hooks.pgvector_hook'"},{"fix":"Run: CREATE EXTENSION vector; in your PostgreSQL database with superuser privileges.","cause":"pgvector extension is not installed in the PostgreSQL database.","error":"psycopg2.errors.UndefinedObject: type \"vector\" does not exist"}],"ecosystem":"pypi","meta_description":null,"install_score":null,"install_tag":null,"quickstart_score":null,"quickstart_tag":null}