LangChain.Utilities.Sql 0.16.1-dev.9

This is a prerelease version of LangChain.Utilities.Sql.
There is a newer version of this package available.
See the version list below for details.
dotnet add package LangChain.Utilities.Sql --version 0.16.1-dev.9
                    
NuGet\Install-Package LangChain.Utilities.Sql -Version 0.16.1-dev.9
                    
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="LangChain.Utilities.Sql" Version="0.16.1-dev.9" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="LangChain.Utilities.Sql" Version="0.16.1-dev.9" />
                    
Directory.Packages.props
<PackageReference Include="LangChain.Utilities.Sql" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add LangChain.Utilities.Sql --version 0.16.1-dev.9
                    
#r "nuget: LangChain.Utilities.Sql, 0.16.1-dev.9"
                    
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#addin nuget:?package=LangChain.Utilities.Sql&version=0.16.1-dev.9&prerelease
                    
Install as a Cake Addin
#tool nuget:?package=LangChain.Utilities.Sql&version=0.16.1-dev.9&prerelease
                    
Install as a Cake Tool

šŸ¦œļøšŸ”— LangChain .NET

Nuget package dotnet License: MIT Discord

All Contributors

⚔ Building applications with LLMs through composability ⚔
C# implementation of LangChain. We try to be as close to the original as possible in terms of abstractions, but are open to new entities.

While the SemanticKernel is good and we will use it wherever possible, we believe that it has many limitations and based on Microsoft technologies. We proceed from the position of the maximum choice of available options and are open to using third-party libraries within individual implementations.

I want to note:

  • I’m unlikely to be able to make serious progress alone, so my goal is to unite the efforts of C# developers to create a C# version of LangChain and control the quality of the final project
  • I try to accept any Pull Request within 24 hours (of course, it depends, but I will try)
  • I'm also looking for developers to join the core team. I will sponsor them whenever possible and also share any money received.
  • I also respond quite quickly on Discord for any questions related to the project

Usage

You can use our wiki to get started: https://tryagi.github.io/LangChain/
If the wiki contains unupdated code, you can always take a look at the tests for this
Also see examples for example usage or tests.

// Price to run from zero(create embeddings and request to LLM): 0,015$
// Price to re-run if database is exists: 0,0004$
// Dependencies: LangChain, LangChain.Databases.Sqlite, LangChain.DocumentLoaders.Pdf

// Initialize models
var provider = new OpenAiProvider(
    Environment.GetEnvironmentVariable("OPENAI_API_KEY") ??
    throw new InconclusiveException("OPENAI_API_KEY is not set"));
var llm = new OpenAiLatestFastChatModel(provider);
var embeddingModel = new TextEmbeddingV3SmallModel(provider);

// Create vector database from Harry Potter book pdf
using var vectorDatabase = new SqLiteVectorDatabase(dataSource: "vectors.db");
var vectorCollection = await vectorDatabase.AddDocumentsFromAsync<PdfPigPdfLoader>(
    embeddingModel, // Used to convert text to embeddings
    dimensions: 1536, // Should be 1536 for TextEmbeddingV3SmallModel
    dataSource: DataSource.FromUrl("https://canonburyprimaryschool.co.uk/wp-content/uploads/2016/01/Joanne-K.-Rowling-Harry-Potter-Book-1-Harry-Potter-and-the-Philosophers-Stone-EnglishOnlineClub.com_.pdf"),
    collectionName: "harrypotter", // Can be omitted, use if you want to have multiple collections
    textSplitter: null); // Default is CharacterTextSplitter(ChunkSize = 4000, ChunkOverlap = 200)

// Now we have two ways: use the async methods or use the chains
// 1. Async methods

// Find similar documents for the question
const string question = "Who was drinking a unicorn blood?";
var similarDocuments = await vectorCollection.GetSimilarDocuments(embeddingModel, question, amount: 5);

// Use similar documents and LLM to answer the question
var answer = await llm.GenerateAsync(
    $"""
     Use the following pieces of context to answer the question at the end.
     If the answer is not in context then just say that you don't know, don't try to make up an answer.
     Keep the answer as short as possible.

     {similarDocuments.AsString()}

     Question: {question}
     Helpful Answer:
     """);

Console.WriteLine($"LLM answer: {answer}"); // The cloaked figure.

// 2. Chains
var promptTemplate =
    @"Use the following pieces of context to answer the question at the end. If the answer is not in context then just say that you don't know, don't try to make up an answer. Keep the answer as short as possible. Always quote the context in your answer.
{context}
Question: {text}
Helpful Answer:";

var chain =
    Set("Who was drinking a unicorn blood?")     // set the question (default key is "text")
    | RetrieveSimilarDocuments(vectorCollection, embeddingModel, amount: 5) // take 5 most similar documents
    | CombineDocuments(outputKey: "context")     // combine documents together and put them into context
    | Template(promptTemplate)                   // replace context and question in the prompt with their values
    | LLM(llm.UseConsoleForDebug());             // send the result to the language model
var chainAnswer = await chain.RunAsync("text");  // get chain result

Console.WriteLine("Chain Answer:"+ chainAnswer);       // print the result
        
Console.WriteLine($"LLM usage: {llm.Usage}");    // Print usage and price
Console.WriteLine($"Embedding model usage: {embeddingModel.Usage}");   // Print usage and price
  • LangChainChat - Allows you to run a chat based on a Blazor project using LangChain.Serve and any of the supported local or paid models

🌟 Contributors

langchain.net contributors

Support

Priority place for bugs: https://github.com/tryAGI/LangChain/issues
Priority place for ideas and general questions: https://github.com/tryAGI/LangChain/discussions
Discord: https://discord.gg/Ca2xhfBf3v

It's licensed under the MIT license. We do not plan to change the license in any foreseeable future for this project, but projects based on this within the organization may have different licenses.
Some documentation is based on documentation from dotnet/docs repository under CC BY 4.0 license, where code examples are changed to code examples for using this project.

Acknowledgments

JetBrains logo

This project is supported by JetBrains through the Open Source Support Program.

CodeRabbit logo

This project is supported by CodeRabbit through the Open Source Support Program.

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 is compatible.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net461 was computed.  net462 is compatible.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on LangChain.Utilities.Sql:

Package Downloads
LangChain.Utilities.Postgres

LangChain Utilities PostgresDatabase.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
0.17.1-dev.51 129 5/20/2025
0.17.1-dev.47 48 5/3/2025
0.17.1-dev.45 129 4/23/2025
0.17.1-dev.44 128 4/22/2025
0.17.1-dev.42 126 4/22/2025
0.17.1-dev.41 137 4/22/2025
0.17.1-dev.40 127 4/22/2025
0.17.1-dev.39 132 4/21/2025
0.17.1-dev.38 134 4/19/2025
0.17.1-dev.37 128 4/19/2025
0.17.1-dev.35 97 4/18/2025
0.17.1-dev.34 104 4/18/2025
0.17.1-dev.33 108 4/18/2025
0.17.1-dev.32 108 4/18/2025
0.17.1-dev.27 123 4/1/2025
0.17.1-dev.26 125 4/1/2025
0.17.1-dev.25 131 4/1/2025
0.17.1-dev.23 78 3/29/2025
0.17.1-dev.20 139 3/23/2025
0.17.1-dev.19 128 3/23/2025
0.17.1-dev.18 129 3/23/2025
0.17.1-dev.17 124 3/23/2025
0.17.1-dev.16 120 3/18/2025
0.17.1-dev.12 56 3/1/2025
0.17.1-dev.11 52 3/1/2025
0.17.1-dev.10 52 3/1/2025
0.17.1-dev.9 49 2/28/2025
0.17.1-dev.7 65 2/26/2025
0.17.1-dev.5 66 2/20/2025
0.17.0 466 1/31/2025
0.16.1-dev.9 71 1/31/2025
0.16.1-dev.5 39 1/15/2025
0.16.1-dev.3 67 1/7/2025
0.16.1-dev.1 65 1/6/2025
0.16.0 142 1/5/2025
0.15.3-dev.31 63 1/5/2025
0.15.3-dev.30 64 1/5/2025
0.15.3-dev.21 72 12/10/2024
0.15.3-dev.20 62 12/10/2024
0.15.3-dev.14 60 11/13/2024
0.15.3-dev.12 65 11/2/2024
0.15.3-dev.8 73 10/11/2024
0.15.2 273 9/19/2024
0.15.1-dev.130 68 9/18/2024
0.15.1-dev.129 75 9/17/2024
0.15.1-dev.126 80 9/14/2024
0.15.1-dev.125 69 9/12/2024
0.15.1-dev.124 65 9/12/2024
0.15.1-dev.123 61 9/12/2024
0.15.1-dev.122 66 9/12/2024
0.15.1-dev.120 67 9/11/2024
0.15.1-dev.118 65 9/10/2024
0.15.1-dev.116 69 9/5/2024
0.15.1-dev.115 71 9/3/2024
0.15.1-dev.112 59 9/1/2024
0.15.1-dev.111 63 9/1/2024
0.15.1-dev.104 97 8/22/2024
0.15.1-dev.100 88 8/21/2024
0.15.1-dev.98 87 8/20/2024
0.15.1-dev.96 89 8/20/2024
0.15.1-dev.95 88 8/20/2024
0.15.1-dev.94 94 8/20/2024
0.15.1-dev.90 86 8/18/2024
0.15.1-dev.89 93 8/16/2024
0.15.1-dev.86 81 8/14/2024
0.15.1-dev.79 48 8/6/2024
0.15.1-dev.78 53 8/6/2024
0.15.1-dev.77 48 8/6/2024
0.15.1-dev.76 59 8/6/2024
0.15.1-dev.69 46 8/4/2024
0.15.1-dev.68 50 8/3/2024
0.15.1-dev.67 49 8/3/2024
0.15.1-dev.65 46 8/3/2024
0.15.1-dev.63 66 8/1/2024
0.15.1-dev.51 58 7/30/2024
0.15.1-dev.46 69 7/27/2024
0.15.1-dev.43 69 7/25/2024
0.15.1-dev.42 73 7/24/2024
0.15.1-dev.41 77 7/24/2024
0.15.1-dev.39 66 7/24/2024
0.15.1-dev.37 72 7/24/2024
0.15.1-dev.35 75 7/22/2024
0.15.1-dev.34 70 7/22/2024
0.15.1-dev.31 75 7/21/2024
0.15.1-dev.12 50 7/11/2024
0.15.1-dev.11 48 7/11/2024
0.15.1-dev.1 78 6/27/2024
0.15.0 198 6/27/2024
0.14.1-dev.79 71 6/26/2024
0.14.1-dev.73 77 6/19/2024
0.14.1-dev.69 68 6/14/2024
0.14.1-dev.66 59 6/11/2024
0.14.1-dev.65 65 6/11/2024
0.14.1-dev.60 62 6/8/2024
0.14.1-dev.57 71 6/6/2024
0.14.1-dev.52 62 6/3/2024
0.14.1-dev.51 66 6/3/2024
0.14.1-dev.49 71 6/1/2024
0.14.1-dev.48 60 6/1/2024
0.14.1-dev.47 70 5/31/2024
0.14.1-dev.43 72 5/23/2024
0.14.1-dev.42 81 5/23/2024
0.14.1-dev.39 77 5/21/2024
0.14.1-dev.35 74 5/19/2024
0.14.1-dev.34 69 5/18/2024
0.14.1-dev.33 68 5/18/2024
0.14.1-dev.31 69 5/17/2024
0.14.1-dev.30 72 5/17/2024
0.14.1-dev.25 68 5/15/2024
0.14.1-dev.24 71 5/15/2024
0.14.1-dev.21 72 5/13/2024
0.14.1-dev.17 69 5/13/2024
0.14.1-dev.14 63 5/12/2024
0.14.1-dev.11 77 5/8/2024
0.14.1-dev.10 74 5/8/2024
0.14.1-dev.8 76 5/5/2024
0.14.1-dev.7 78 5/5/2024
0.14.1-dev.6 85 5/5/2024
0.14.1-dev.5 76 5/5/2024
0.14.1-dev.2 76 5/3/2024
0.14.1-dev.1 63 5/3/2024
0.14.0 190 5/3/2024
0.13.1-dev.184 71 5/3/2024
0.13.1-dev.183 64 5/3/2024
0.13.1-dev.179 37 5/2/2024
0.13.1-dev.178 41 5/2/2024
0.13.1-dev.177 36 5/2/2024
0.13.1-dev.175 41 5/2/2024
0.13.1-dev.171 37 5/2/2024
0.13.1-dev.169 63 5/1/2024
0.13.1-dev.161 75 4/30/2024
0.13.1-dev.157 73 4/29/2024
0.13.1-dev.154 74 4/29/2024
0.13.1-dev.150 81 4/29/2024
0.13.1-dev.145 79 4/29/2024
0.13.1-dev.144 67 4/29/2024
0.13.1-dev.142 65 4/29/2024
0.13.1-dev.141 67 4/29/2024
0.13.1-dev.138 64 4/29/2024
0.13.1-dev.137 68 4/29/2024
0.13.1-dev.136 69 4/29/2024
0.13.1-dev.131 78 4/28/2024
0.13.1-dev.121 68 4/27/2024
0.13.1-dev.119 72 4/27/2024
0.13.1-dev.116 80 4/26/2024
0.13.1-dev.112 76 4/25/2024
0.13.1-dev.110 72 4/25/2024
0.13.1-dev.107 68 4/24/2024
0.13.1-dev.106 67 4/24/2024
0.13.1-dev.103 76 4/23/2024
0.13.1-dev.102 66 4/23/2024
0.13.1-dev.101 75 4/23/2024
0.13.1-dev.99 76 4/22/2024
0.13.1-dev.97 72 4/22/2024
0.13.1-dev.96 67 4/22/2024
0.13.1-dev.95 74 4/21/2024
0.13.1-dev.94 66 4/21/2024
0.13.1-dev.93 74 4/21/2024
0.13.1-dev.92 67 4/20/2024
0.13.1-dev.91 79 4/20/2024
0.13.1-dev.90 68 4/20/2024
0.13.1-dev.87 74 4/20/2024
0.13.1-dev.85 67 4/20/2024
0.13.1-dev.84 71 4/20/2024
0.13.1-dev.83 73 4/20/2024
0.13.1-dev.82 68 4/20/2024
0.13.1-dev.81 75 4/20/2024
0.13.1-dev.80 82 4/20/2024
0.13.1-dev.79 76 4/20/2024
0.13.1-dev.78 71 4/20/2024
0.13.1-dev.77 67 4/20/2024
0.13.1-dev.76 69 4/20/2024
0.13.1-dev.75 72 4/20/2024
0.13.1-dev.74 72 4/20/2024
0.13.1-dev.73 73 4/20/2024
0.13.1-dev.72 67 4/20/2024
0.13.1-dev.71 68 4/20/2024
0.13.1-dev.70 67 4/20/2024
0.13.1-dev.69 76 4/20/2024
0.13.1-dev.68 73 4/20/2024
0.13.1-dev.67 68 4/20/2024
0.13.1-dev.66 64 4/20/2024
0.13.1-dev.65 67 4/20/2024
0.13.1-dev.64 70 4/20/2024
0.13.1-dev.63 79 4/20/2024
0.13.1-dev.62 77 4/20/2024
0.13.1-dev.61 76 4/20/2024
0.13.1-dev.60 72 4/20/2024
0.13.1-dev.59 69 4/20/2024
0.13.1-dev.57 67 4/20/2024
0.13.1-dev.56 77 4/20/2024
0.13.1-dev.55 71 4/20/2024
0.13.1-dev.54 63 4/20/2024
0.13.1-dev.53 67 4/20/2024
0.13.1-dev.52 67 4/19/2024
0.13.1-dev.51 61 4/19/2024
0.13.1-dev.50 72 4/18/2024
0.13.1-dev.49 84 4/15/2024
0.13.1-dev.48 73 4/15/2024
0.13.1-dev.47 78 4/14/2024
0.13.1-dev.45 71 4/13/2024
0.13.1-dev.44 80 4/13/2024
0.13.1-dev.43 71 4/13/2024
0.13.1-dev.41 74 4/13/2024
0.13.1-dev.40 79 4/12/2024
0.13.1-dev.39 68 4/11/2024
0.13.1-dev.38 70 4/10/2024
0.13.1-dev.37 76 4/9/2024
0.13.1-dev.36 77 4/8/2024
0.13.1-dev.35 72 4/7/2024
0.13.1-dev.34 77 4/7/2024
0.13.1-dev.33 78 4/7/2024
0.13.1-dev.32 72 4/6/2024
0.13.1-dev.31 77 4/5/2024
0.13.1-dev.29 64 4/5/2024
0.13.1-dev.28 69 4/5/2024
0.13.1-dev.27 70 4/4/2024
0.13.1-dev.26 81 4/3/2024
0.13.1-dev.25 77 4/3/2024
0.13.1-dev.24 72 4/3/2024
0.13.1-dev.22 77 4/3/2024
0.13.1-dev.21 68 4/3/2024
0.13.1-dev.20 78 4/3/2024
0.13.1-dev.19 79 4/3/2024
0.13.1-dev.18 69 4/3/2024
0.13.1-dev.17 81 4/2/2024
0.13.1-dev.16 87 4/1/2024
0.13.1-dev.15 75 4/1/2024
0.13.1-dev.13 80 3/30/2024
0.13.1-dev.12 72 3/27/2024
0.13.1-dev.11 82 3/24/2024
0.13.1-dev.10 77 3/23/2024
0.13.1-dev.9 76 3/22/2024
0.13.1-dev.7 72 3/18/2024
0.13.1-dev.5 80 3/9/2024
0.13.1-dev.3 72 3/7/2024
0.13.1-dev.2 72 3/7/2024
0.13.1-dev.1 76 3/6/2024
0.13.0 213 3/6/2024
0.12.3-dev.157 82 3/6/2024
0.12.3-dev.156 79 3/6/2024
0.12.3-dev.155 76 3/6/2024
0.12.3-dev.151 67 3/5/2024
0.12.3-dev.150 78 3/4/2024
0.12.3-dev.149 72 3/4/2024
0.12.3-dev.148 78 3/4/2024
0.12.3-dev.147 71 3/3/2024
0.12.3-dev.145 71 3/3/2024
0.12.3-dev.144 75 3/3/2024
0.12.3-dev.143 77 3/3/2024
0.12.3-dev.142 83 3/2/2024
0.12.3-dev.141 69 3/2/2024
0.12.3-dev.140 74 2/29/2024
0.12.3-dev.139 78 2/29/2024
0.12.3-dev.137 77 2/28/2024
0.12.3-dev.134 62 2/28/2024
0.12.3-dev.133 67 2/28/2024
0.12.3-dev.132 73 2/27/2024
0.12.3-dev.131 72 2/26/2024
0.12.3-dev.130 73 2/26/2024
0.12.3-dev.128 70 2/25/2024
0.12.3-dev.127 76 2/25/2024
0.12.3-dev.120 81 2/24/2024
0.12.3-dev.119 79 2/24/2024
0.12.3-dev.118 69 2/23/2024
0.12.3-dev.116 72 2/23/2024
0.12.3-dev.115 70 2/23/2024
0.12.3-dev.114 86 2/19/2024
0.12.3-dev.113 87 2/12/2024
0.12.3-dev.110 78 2/8/2024
0.12.3-dev.108 78 2/7/2024
0.12.3-dev.107 83 2/6/2024
0.12.3-dev.106 82 2/4/2024
0.12.3-dev.103 80 2/1/2024
0.12.3-dev.102 75 1/31/2024
0.12.3-dev.100 74 1/31/2024
0.12.3-dev.99 75 1/28/2024
0.12.3-dev.98 73 1/27/2024
0.12.3-dev.97 82 1/27/2024
0.12.3-dev.95 79 1/26/2024
0.12.3-dev.94 74 1/24/2024
0.12.3-dev.93 77 1/22/2024
0.12.3-dev.92 82 1/21/2024
0.12.3-dev.91 69 1/21/2024
0.12.3-dev.88 75 1/18/2024
0.12.3-dev.87 82 1/18/2024
0.12.3-dev.85 79 1/14/2024
0.12.3-dev.84 79 1/14/2024
0.12.3-dev.83 79 1/10/2024
0.12.3-dev.82 84 1/9/2024
0.12.3-dev.81 85 1/7/2024
0.12.3-dev.80 78 1/6/2024
0.12.3-dev.79 87 1/6/2024
0.12.3-dev.78 85 1/6/2024
0.12.3-dev.77 79 1/6/2024
0.12.3-dev.76 92 1/6/2024
0.12.3-dev.75 82 1/6/2024
0.12.3-dev.74 77 1/6/2024
0.12.3-dev.72 81 1/5/2024
0.12.3-dev.71 81 1/4/2024
0.12.3-dev.69 98 1/1/2024
0.12.3-dev.68 90 12/29/2023
0.12.3-dev.65 98 12/20/2023
0.12.3-dev.64 114 12/8/2023
0.12.3-dev.63 89 12/6/2023
0.12.3-dev.62 95 12/5/2023
0.12.3-dev.61 92 12/5/2023
0.12.3-dev.60 98 12/5/2023
0.12.3-dev.41 85 12/4/2023
0.12.3-dev.40 85 12/1/2023
0.12.3-dev.39 74 11/29/2023