*[Overview](api/apis.md)

*[SQL Extension](api/sql-extensions/README.md)

*[pgml.deploy()](api/sql-extensions/pgml.deploy.md)

*[pgml.embed()](api/sql-extensions/pgml.embed.md)

*[pgml.generate()](api/sql-extensions/pgml.generate.md)

*[pgml.predict()](api/sql-extensions/pgml.predict/README.md)

*[Batch Predictions](api/sql-extensions/pgml.predict/batch-predictions.md)

*[pgml.train()](api/sql-extensions/pgml.train/README.md)

*[Regression](api/sql-extensions/pgml.train/regression.md)

*[Classification](api/sql-extensions/pgml.train/classification.md)

*[Clustering](api/sql-extensions/pgml.train/clustering.md)

*[Data Pre-processing](api/sql-extensions/pgml.train/data-pre-processing.md)

*[Hyperparameter Search](api/sql-extensions/pgml.train/hyperparameter-search.md)

*[Joint Optimization](api/sql-extensions/pgml.train/joint-optimization.md)

*[pgml.transform()](api/sql-extensions/pgml.transform/README.md)

*[Fill Mask](api/sql-extensions/pgml.transform/fill-mask.md)

*[Question Answering](api/sql-extensions/pgml.transform/question-answering.md)

*[Summarization](api/sql-extensions/pgml.transform/summarization.md)

*[Text Classification](api/sql-extensions/pgml.transform/text-classification.md)

*[Text Generation](api/sql-extensions/pgml.transform/text-generation.md)

*[Text-to-Text Generation](api/sql-extensions/pgml.transform/text-to-text-generation.md)

*[Token Classification](api/sql-extensions/pgml.transform/token-classification.md)

*[Translation](api/sql-extensions/pgml.transform/translation.md)

*[Zero-shot Classification](api/sql-extensions/pgml.transform/zero-shot-classification.md)

*[pgml.tune()](api/sql-extensions/pgml.tune.md)

*[Client SDK](api/client-sdks/README.md)

*[Overview](api/client-sdks/getting-started.md)

*[Collections](api/client-sdks/collections.md)

*[Pipelines](api/client-sdks/pipelines.md)

*[Vector Search](api/client-sdks/search.md)

*[Document Search](api/client-sdks/document-search.md)

*[Tutorials](api/client-sdks/tutorials/README.md)

*[Semantic Search](api/client-sdks/tutorials/semantic-search.md)

*[Semantic Search Using Instructor Model](api/client-sdks/tutorials/semantic-search-1.md)

*[SQL Extension](api/sql-extension/README.md)

*[pgml.deploy()](api/sql-extension/pgml.deploy.md)

*[pgml.embed()](api/sql-extension/pgml.embed.md)

*[pgml.generate()](api/sql-extension/pgml.generate.md)

*[pgml.predict()](api/sql-extension/pgml.predict/README.md)

*[Batch Predictions](api/sql-extension/pgml.predict/batch-predictions.md)

*[pgml.train()](api/sql-extension/pgml.train/README.md)

*[Regression](api/sql-extension/pgml.train/regression.md)

*[Classification](api/sql-extension/pgml.train/classification.md)

*[Clustering](api/sql-extension/pgml.train/clustering.md)

*[Data Pre-processing](api/sql-extension/pgml.train/data-pre-processing.md)

*[Hyperparameter Search](api/sql-extension/pgml.train/hyperparameter-search.md)

*[Joint Optimization](api/sql-extension/pgml.train/joint-optimization.md)

*[pgml.transform()](api/sql-extension/pgml.transform/README.md)

*[Fill Mask](api/sql-extension/pgml.transform/fill-mask.md)

*[Question Answering](api/sql-extension/pgml.transform/question-answering.md)

*[Summarization](api/sql-extension/pgml.transform/summarization.md)

*[Text Classification](api/sql-extension/pgml.transform/text-classification.md)

*[Text Generation](api/sql-extension/pgml.transform/text-generation.md)

*[Text-to-Text Generation](api/sql-extension/pgml.transform/text-to-text-generation.md)

*[Token Classification](api/sql-extension/pgml.transform/token-classification.md)

*[Translation](api/sql-extension/pgml.transform/translation.md)

*[Zero-shot Classification](api/sql-extension/pgml.transform/zero-shot-classification.md)

*[pgml.tune()](api/sql-extension/pgml.tune.md)

*[Client SDK](api/client-sdk/README.md)

*[Overview](api/client-sdk/getting-started.md)

*[Collections](api/client-sdk/collections.md)

*[Pipelines](api/client-sdk/pipelines.md)

*[Vector Search](api/client-sdk/search.md)

*[Document Search](api/client-sdk/document-search.md)

*[Tutorials](api/client-sdk/tutorials/README.md)

*[Semantic Search](api/client-sdk/tutorials/semantic-search.md)

*[Semantic Search Using Instructor Model](api/client-sdk/tutorials/semantic-search-1.md)

***pgml** - provides Machine Learning and Artificial Intelligence APIs with access to more than 50 ML algorithms to train classification, clustering and regression models on your own data, or you can perform dozens of tasks with thousands of models downloaded from HuggingFace.

***pgvector** - provides indexing and search functionality on vectors, in addition to the traditional application database storage, including JSON and plain text, provided by PostgreSQL.

Learn more about developing with the[sql-extensions](sql-extensions/"mention")

Learn more about developing with the[sql-extension](sql-extension/"mention")

PostgresML provides a client SDK that streamlines ML & AI use cases in both JavaScript and Python. With this SDK, you can seamlessly manage various database tables related to documents, text chunks, text splitters, LLM (Language Model) models, and embeddings. By leveraging the SDK's capabilities, you can efficiently index LLM embeddings using pgvector with HNSW for fast and accurate queries.

The SDK delegates all work to the extension running in the database, which minimizes software and hardware dependencies that need to be maintained at the application layer, as well as securing data and models inside the data center. Our SDK minimizes data transfer to maximize performance, efficiency, security and reliability.

Learn more about developing with the[client-sdks](client-sdks/"mention")

Learn more about developing with the[client-sdk](client-sdk/"mention")