LibreAI / Développement / postgresml
// devtools · postgresml/postgresml

postgresml

postgresml est un projet de développement open source, créé par postgresml (postgresml/postgresml sur GitHub). Il compte 6 821 étoiles sur GitHub et 364 forks, il est publié sous la licence MIT et a été mis à jour pour la dernière fois sur GitHub le 1er juillet 2025.

PostgresML — machine learning inside PostgreSQL with GPU acceleration: train, embed and run LLMs in SQL.

★ 6,8 k étoiles⑂ 364 forksMITmis à jour juil. 2025
▦ visuel — le README de ce projet ne contient aucune capture intégrable,
voici donc un emplacement réservé. Le guide ci-dessous est complet malgré tout.
// détails du projet

Détails du projet

Étoiles GitHub
6 821
Forks
364
Licence
MIT
Dernière mise à jour sur GitHub
1er juillet 2025
Catégorie
Développement
Type de fiche
Guide d'installation complet
Site officiel
Official site
// fonctionnement

Comment ça marche

  1. Clarify your goal

    Decide cloud versus self-hosted, and pick a first workload: in-database training, embeddings/RAG, or LLM calls from SQL.

  2. Get the project

    Clone postgresml/postgresml from GitHub (or use the install path in the run steps below) and skim its README for the parts relevant to your goal.

  3. Install and configure

    The fastest self-hosted path is the documented Docker image with a persistent volume; PostgresML Cloud skips installation entirely.

  4. Run your first task

    Connect with psql, run one in-database ML or embedding query on a sample table, and compare it with your current HTTP-serving approach.

// fonctionnalités

Pourquoi on l'adore

In-database ML and AI

Run machine learning and AI operations directly within PostgreSQL, keeping models and data together for privacy and simplicity.

GPU acceleration

Leverage GPU power for faster training computations and model inference inside the database.

LLMs from Hugging Face

Integrate and use state-of-the-art LLMs from Hugging Face in your SQL workflows.

Built-in RAG pipeline

Functions for chunking, embedding, ranking and transforming text, with vector search via pgvector integration.

47+ algorithms

A diverse set of classification and regression algorithms available in-database for classic ML tasks.

Performance and scale

Positions inference as 8–40x faster than HTTP-based serving in its benchmarks, with horizontal scaling support.

Advertisement
// lancez-le

Lancez-le vous-même

  1. Clone the repository

    Get the source from the official GitHub repository for postgresml.

    git clone https://github.com/postgresml/postgresml.git
    cd postgresml
  2. Run PostgresML with Docker

    Start the published image with its data volume and ports exactly as the README's self-hosted section shows.

    docker run -it -v postgresml_data:/var/lib/postgresql -p 5433:5432 -p 8000:8000 ghcr.io/postgresml/postgresml:2.10.0 sudo -u postgresml psql -d postgresml
  3. Try an in-database query

    Once connected, follow the README/docs examples to run an embedding, RAG or training query in SQL.

    # Connect to the postgresml database and run a documented example query — see README
// cas d'usage

Ce que vous pouvez créer

Advertisement
// faq

Questions fréquentes

Who maintains postgresml?

The PostgresML project, through the postgresml/postgresml repository, with the site and cloud at postgresml.org.

Is postgresml free to use?

Yes — the project is open source under the MIT license as recorded for this listing. You can use, modify and distribute it under the MIT terms.

Does postgresml need a paid API key?

Self-hosting is free under MIT with no API key; PostgresML Cloud is the paid managed option. GPU features need GPU hardware you provide.

How does PostgresML compare to serving models behind a separate inference API?

A separate API means network hops, duplicated data pipelines and another service to secure. PostgresML moves training and inference into Postgres itself — simpler data flow and lower latency in its benchmarks, in exchange for running ML inside your database tier.

How do I get started with postgresml?

Clone the repository (or use the documented installer), follow the install and configure steps on this page, and run the smallest real task first — connect with psql, run one in-database ML or embedding query on a sample table, and compare it with your current HTTP-serving approach.

// continuez l'exploration

Outils similaires

Développement

Gradio

Build machine-learning web demos in Python within minutes — the fastest way to share a model with the world.

★ 43,7 k étoilesApache-2.0
Voir le guide →
Développement

no_human

From ticket to reviewed pull request — an autonomous coding pipeline on your machine.

★ 329 étoilesMIT
Voir le guide →
Développement

WrenAI

GenBI for AI agents - governed text-to-SQL and dashboards through an open context layer

★ 17,8 k étoilesNOASSERTION
Voir le guide →
Développement

newton

A GPU-accelerated, differentiable physics engine on NVIDIA Warp for robotics simulation.

★ 5,7 k étoilesApache-2.0
Voir le guide →
Développement

lazycodex

The agent harness for complex codebases inside Codex — project memory, planning and verified completion.

★ 3,7 k étoilesMIT
Voir le guide →
Développement

grepai

grepai: semantic code search and call graphs for AI agents, running 100% locally on your machine.

★ 1,9 k étoilesMIT
Voir le guide →
// alternatives

Alternatives en Développement

Les autres projets de la catégorie Développement avec le plus d'étoiles du catalogue LibreAI — la sélection réaliste d'alternatives si postgresml ne vous convient pas.

// plus en devtools

Plus en Développement

Projets de la catégorie Développement proches dans le catalogue, les plus proches en étoiles de postgresml — continuez à explorer de part et d'autre.

Obtenir postgresml

Gratuit et ouvert : récupérez le code source, mettez une étoile au dépôt et commencez à créer.