{"data":{"slug":"postgresml-postgresml","name":"postgresml","tagline":"Postgres with GPUs for ML/AI apps","github_url":"https://github.com/postgresml/postgresml","owner":"postgresml","repo":"postgresml","owner_avatar_url":"https://avatars.githubusercontent.com/u/103390393?v=4","primary_language":"Rust","stars":6817,"forks":365,"topics":["ai","ann","approximate-nearest-neighbor-search","artificial-intelligence","classification","clustering","embeddings","forecasting","knn","llm","machine-learning","ml","postgres","rag","regression","sql","vector-database"],"archived":false,"github_pushed_at":"2025-07-01T12:26:02+00:00","maintenance_label":"Dormant","stars_delta_30d":3,"url":"https://www.graphcanon.com/tools/postgresml-postgresml","markdown_url":"https://www.graphcanon.com/tools/postgresml-postgresml.md","api_url":"https://www.graphcanon.com/api/graphcanon/tools/postgresml-postgresml","graph_url":"https://www.graphcanon.com/api/graphcanon/graph?tool=postgresml-postgresml","description":"Postgres with GPUs for ML/AI apps.","homepage_url":"https://postgresml.org","license":"MIT","open_issues":149,"watchers":56,"ai_summary":"A PostgreSQL extension (`pgml`) designed to enhance machine learning and AI applications, supporting GPU acceleration.","readme_excerpt":"# Getting started\n\nThe only prerequisites for using PostgresML is a Postgres database with our open-source `pgml` extension installed.","github_created_at":"2022-04-11T05:33:26+00:00","created_at":"2026-07-07T17:37:31.632331+00:00","updated_at":"2026-08-18T12:01:27.240617+00:00","categories":[{"slug":"data-retrieval","name":"Data & Retrieval","url":"https://www.graphcanon.com/categories/data-retrieval","markdown_url":"https://www.graphcanon.com/categories/data-retrieval.md","api_url":"https://www.graphcanon.com/api/graphcanon/categories/data-retrieval"},{"slug":"model-training","name":"Model Training","url":"https://www.graphcanon.com/categories/model-training","markdown_url":"https://www.graphcanon.com/categories/model-training.md","api_url":"https://www.graphcanon.com/api/graphcanon/categories/model-training"},{"slug":"vector-databases","name":"Vector Databases","url":"https://www.graphcanon.com/categories/vector-databases","markdown_url":"https://www.graphcanon.com/categories/vector-databases.md","api_url":"https://www.graphcanon.com/api/graphcanon/categories/vector-databases"}],"tags":[{"slug":"ai","name":"ai"},{"slug":"ann","name":"ann"},{"slug":"approximate-nearest-neighbor-search","name":"approximate-nearest-neighbor-search"},{"slug":"classification","name":"classification"},{"slug":"clustering","name":"clustering"},{"slug":"embeddings","name":"embeddings"},{"slug":"forecasting","name":"forecasting"},{"slug":"knn","name":"knn"}],"trust":{"provenance":{"is_fork":false,"github_id":480239936,"owner_type":"Organization","methodology":"github_public_v1","parent_repo":null,"near_duplicate_slugs":[]},"computed_at":"2026-08-18T12:01:26.507Z","maintenance":{"label":"Dormant","score":18,"methodology":"github_public_v1","releases_90d":0,"days_since_push":412,"last_release_at":"2025-01-16T23:45:14Z","stars_delta_30d":3,"open_issues_delta_30d":0},"security_summary":{"status":"no_lockfile","scanner":null,"low_count":0,"high_count":0,"last_scan_at":"2026-07-11T11:09:49.801Z","medium_count":0,"scan_profile":"none","critical_count":0}},"capability_facts":{"scan":{"source":"repo_scan","observed_at":"2026-08-18T12:01:26.948Z"},"languages":{"value":["rust"],"source":"github.language","observed_at":"2026-08-18T12:01:26.948Z"},"license_spdx":{"value":"MIT","source":"github.license","observed_at":"2026-08-18T12:01:26.948Z"}},"decision_facts":{"hosting":null,"pricing":null,"requirements":null,"constraints":null,"when_to_use":["Requires integration of machine learning tasks directly within PostgreSQL queries","Projects already heavily invested in Postgres ecosystem but aiming for faster AI/ML performance"],"when_not_to_use":["Teams not utilizing or unwilling to migrate to PostgreSQL databases","Applications where GPU access is limited, thus constraining ML capabilities"],"source":"enrich:decision_facts","observed_at":"2026-07-12T14:02:36.097Z"},"constraint_facets":null,"decision_summary":[{"label":"Adopt for","value":"PostgresML offers PostgreSQL with GPU acceleration for ML, distinguishing by its support of embedding operations directly into SQL queries."}]}}