• Client Library Documentation

• Product Documentation

Quick Start

In order to use this library, you first need to go through the followingsteps:

1. Select or create a Cloud Platform project.

2. Enable billing for your project.

3. Enable the Google Cloud SQL Admin API.

4. Setup Authentication.

Installation

Install this library in avirtualenv using pip.virtualenv is a tool to create isolated Python environments. The basic problem it addresses isone of dependencies and versions, and indirectly permissions.

Withvirtualenv, it’s possible to install this library without needing system install permissions, and without clashing with the installed system dependencies.

Supported Python Versions

Python >= 3.9

Mac/Linux

pip install virtualenvvirtualenv <your-env>source <your-env>/bin/activate<your-env>/bin/pip install langchain-google-cloud-sql-mssql

Windows

pip install virtualenvvirtualenv <your-env><your-env>\Scripts\activate<your-env>\Scripts\pip.exe install langchain-google-cloud-sql-mssql

Document Loader Usage

Use a document loader to load data as LangChainDocuments.

from langchain_google_cloud_sql_mssql import MSSQLEngine, MSSQLLoaderengine = MSSQLEngine.from_instance("project-id", "region", "my-instance", "my-database", "db_user", "db_pass")loader = MSSQLLoader(    engine,    table_name="my-table-name")docs = loader.lazy_load()

See the fullDocument Loader tutorial.

Chat Message History Usage

UseChatMessageHistory to store messages and provide conversationhistory to LLMs.

from langchain_google_cloud_sql_mssql import MSSQLChatMessageHistory, MSSQLEngineengine = MSSQLEngine.from_instance("project-id", "region", "my-instance", "my-database", "db_user", "db_pass")history = MSSQLChatMessageHistory(    engine,    table_name="my-message-store",    session_id="my-session_id")

See the fullChat Message History tutorial.

Contributions

Contributions to this library are always welcome and highly encouraged.

SeeCONTRIBUTING for more information how to get started.

Please note that this project is released with a Contributor Code of Conduct. By participating inthis project you agree to abide by its terms. SeeCode of Conduct for moreinformation.

License

Apache 2.0 - SeeLICENSEfor more information.

Disclaimer

This is not an officially supported Google product.