LangChain.Utilities.Sql 0.12.3-dev.63

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.12.3-dev.63
NuGet\Install-Package LangChain.Utilities.Sql -Version 0.12.3-dev.63
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.12.3-dev.63" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add LangChain.Utilities.Sql --version 0.12.3-dev.63
#r "nuget: LangChain.Utilities.Sql, 0.12.3-dev.63"
#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.
// Install LangChain.Utilities.Sql as a Cake Addin
#addin nuget:?package=LangChain.Utilities.Sql&version=0.12.3-dev.63&prerelease

// Install LangChain.Utilities.Sql as a Cake Tool
#tool nuget:?package=LangChain.Utilities.Sql&version=0.12.3-dev.63&prerelease

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

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.
ā¤ļø Our project includes https://github.com/jeastham1993/langchain-dotnet and tries to be updated with the latest changes there ā¤ļø

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

const string apiKey = "API_KEY";
using var httpClient = new HttpClient();
var model = new Gpt4Model(apiKey, httpClient);
var response = await model.GenerateAsync("Hello, World of AI!");

var numberOfTokens = model.CountTokens("Hello, World of AI!");

Chains

const string apiKey = "API_KEY";
using var httpClient = new HttpClient();
var model = new Gpt4Model(apiKey, httpClient);

var template = "What is a good name for a company that makes {product}?";
var prompt = new PromptTemplate(new PromptTemplateInput(template, new List<string>(1){"product"}));

var chain = new LlmChain(new LlmChainInput(model, prompt));

var result = await chain.CallAsync(new ChainValues(new Dictionary<string, object>(1)
{
    { "product", "colourful socks" }
}));
// The result is an object with a `text` property.
Console.WriteLine(result.Value["text"]);

// Since the LLMChain is a single-input, single-output chain, we can also call it with `run`.
// This takes in a string and returns the `text` property.
var result2 = await chain.Run("colourful socks");

Console.WriteLine(result2);

OpenAI Functions:

WeatherService:

[OpenAiFunctions]
public interface IWeatherFunctions
{
    [Description("Get the current weather in a given location")]
    public Task<Weather> GetCurrentWeatherAsync(
        [Description("The city and state, e.g. San Francisco, CA")] string location,
        Unit unit = Unit.Celsius,
        CancellationToken cancellationToken = default);
}

public class WeatherService : IWeatherFunctions
{
    public Task<Weather> GetCurrentWeatherAsync(string location, Unit unit = Unit.Celsius, CancellationToken cancellationToken = default)
    {
        return Task.FromResult(new Weather
        {
            Location = location,
            Temperature = 22.0,
            Unit = unit,
            Description = "Sunny",
        });
    }
}
using var client = new HttpClient();
var model = new Gpt35TurboModel(apiKey, client);

var service = new WeatherService();
model.AddGlobalFunctions(service.AsFunctions(), service.AsCalls());

var response = await model.GenerateAsync(new ChatRequest(
    Messages: new []
    {
        "You are a helpful weather assistant.".AsSystemMessage(),
        "What's the weather like today?".AsHumanMessage(),
        "Sure! Could you please provide me with your location?".AsAiMessage(),
        "Dubai, UAE".AsHumanMessage(),
    }));

Console.WriteLine(response.Messages.AsHistory());

Result:

System: You are a helpful weather assistant.
Human: What's the weather like today?
AI: Sure! Could you please provide me with your location?
Human: Dubai, UAE
Function call: GetCurrentWeather({"location": "Dubai, UAE"})
Function result: GetCurrentWeather -> {"location":"Dubai, UAE","temperature":22,"unit":"celsius","description":"Sunny"}
AI: The weather in Dubai, UAE today is sunny with a temperature of 22 degrees Celsius.

Also see examples for example usage.

Contributors

<table> <tbody> <tr> <td align="center" valign="top" width="14.28%"><a href="https://www.upwork.com/freelancers/~017b1ad6f6af9cc189"><img src="https://avatars.githubusercontent.com/u/3002068?v=4?s=100" width="100px;" alt="Konstantin S."/><br /><sub><b>Konstantin S.</b></sub></a><br /><a href="#infra-HavenDV" title="Infrastructure (Hosting, Build-Tools, etc)">šŸš‡</a> <a href="https://github.com/tryAGI/LangChain/commits?author=HavenDV" title="Tests">āš ļø</a> <a href="https://github.com/tryAGI/LangChain/commits?author=HavenDV" title="Code">šŸ’»</a></td> <td align="center" valign="top" width="14.28%"><a href="https://github.com/TesAnti"><img src="https://avatars.githubusercontent.com/u/8780022?v=4?s=100" width="100px;" alt="TesAnti"/><br /><sub><b>TesAnti</b></sub></a><br /><a href="#infra-TesAnti" title="Infrastructure (Hosting, Build-Tools, etc)">šŸš‡</a> <a href="https://github.com/tryAGI/LangChain/commits?author=TesAnti" title="Tests">āš ļø</a> <a href="https://github.com/tryAGI/LangChain/commits?author=TesAnti" title="Code">šŸ’»</a></td> <td align="center" valign="top" width="14.28%"><a href="https://github.com/khoroshevj"><img src="https://avatars.githubusercontent.com/u/13628506?v=4?s=100" width="100px;" alt="Khoroshev Evgeniy"/><br /><sub><b>Khoroshev Evgeniy</b></sub></a><br /><a href="#infra-khoroshevj" title="Infrastructure (Hosting, Build-Tools, etc)">šŸš‡</a> <a href="https://github.com/tryAGI/LangChain/commits?author=khoroshevj" title="Tests">āš ļø</a> <a href="https://github.com/tryAGI/LangChain/commits?author=khoroshevj" title="Code">šŸ’»</a></td> <td align="center" valign="top" width="14.28%"><a href="https://github.com/SiegDuch"><img src="https://avatars.githubusercontent.com/u/104992451?v=4?s=100" width="100px;" alt="SiegDuch"/><br /><sub><b>SiegDuch</b></sub></a><br /><a href="#infra-SiegDuch" title="Infrastructure (Hosting, Build-Tools, etc)">šŸš‡</a></td> </tr> </tbody> </table>

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

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 is compatible.  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 is compatible.  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. 
.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.14.1-dev.35 0 5/19/2024
0.14.1-dev.34 34 5/18/2024
0.14.1-dev.33 31 5/18/2024
0.14.1-dev.31 36 5/17/2024
0.14.1-dev.30 42 5/17/2024
0.14.1-dev.25 35 5/15/2024
0.14.1-dev.24 39 5/15/2024
0.14.1-dev.21 39 5/13/2024
0.14.1-dev.17 33 5/13/2024
0.14.1-dev.14 31 5/12/2024
0.14.1-dev.11 44 5/8/2024
0.14.1-dev.10 45 5/8/2024
0.14.1-dev.8 45 5/5/2024
0.14.1-dev.7 40 5/5/2024
0.14.1-dev.6 45 5/5/2024
0.14.1-dev.5 46 5/5/2024
0.14.1-dev.2 38 5/3/2024
0.14.1-dev.1 34 5/3/2024
0.14.0 102 5/3/2024
0.13.1-dev.184 34 5/3/2024
0.13.1-dev.183 30 5/3/2024
0.13.1-dev.179 5 5/2/2024
0.13.1-dev.178 3 5/2/2024
0.13.1-dev.177 3 5/2/2024
0.13.1-dev.175 3 5/2/2024
0.13.1-dev.171 3 5/2/2024
0.13.1-dev.169 24 5/1/2024
0.13.1-dev.161 42 4/30/2024
0.13.1-dev.157 41 4/29/2024
0.13.1-dev.154 40 4/29/2024
0.13.1-dev.150 38 4/29/2024
0.13.1-dev.145 37 4/29/2024
0.13.1-dev.144 34 4/29/2024
0.13.1-dev.142 32 4/29/2024
0.13.1-dev.141 31 4/29/2024
0.13.1-dev.138 36 4/29/2024
0.13.1-dev.137 35 4/29/2024
0.13.1-dev.136 32 4/29/2024
0.13.1-dev.131 39 4/28/2024
0.13.1-dev.121 35 4/27/2024
0.13.1-dev.119 44 4/27/2024
0.13.1-dev.116 47 4/26/2024
0.13.1-dev.112 41 4/25/2024
0.13.1-dev.110 45 4/25/2024
0.13.1-dev.107 42 4/24/2024
0.13.1-dev.106 36 4/24/2024
0.13.1-dev.103 41 4/23/2024
0.13.1-dev.102 38 4/23/2024
0.13.1-dev.101 43 4/23/2024
0.13.1-dev.99 38 4/22/2024
0.13.1-dev.97 43 4/22/2024
0.13.1-dev.96 44 4/22/2024
0.13.1-dev.95 38 4/21/2024
0.13.1-dev.94 39 4/21/2024
0.13.1-dev.93 44 4/21/2024
0.13.1-dev.92 35 4/20/2024
0.13.1-dev.91 42 4/20/2024
0.13.1-dev.90 38 4/20/2024
0.13.1-dev.87 41 4/20/2024
0.13.1-dev.85 39 4/20/2024
0.13.1-dev.84 37 4/20/2024
0.13.1-dev.83 38 4/20/2024
0.13.1-dev.82 38 4/20/2024
0.13.1-dev.81 41 4/20/2024
0.13.1-dev.80 38 4/20/2024
0.13.1-dev.79 41 4/20/2024
0.13.1-dev.78 42 4/20/2024
0.13.1-dev.77 36 4/20/2024
0.13.1-dev.76 34 4/20/2024
0.13.1-dev.75 37 4/20/2024
0.13.1-dev.74 39 4/20/2024
0.13.1-dev.73 44 4/20/2024
0.13.1-dev.72 38 4/20/2024
0.13.1-dev.71 37 4/20/2024
0.13.1-dev.70 41 4/20/2024
0.13.1-dev.69 40 4/20/2024
0.13.1-dev.68 40 4/20/2024
0.13.1-dev.67 39 4/20/2024
0.13.1-dev.66 40 4/20/2024
0.13.1-dev.65 33 4/20/2024
0.13.1-dev.64 33 4/20/2024
0.13.1-dev.63 42 4/20/2024
0.13.1-dev.62 43 4/20/2024
0.13.1-dev.61 36 4/20/2024
0.13.1-dev.60 40 4/20/2024
0.13.1-dev.59 37 4/20/2024
0.13.1-dev.57 37 4/20/2024
0.13.1-dev.56 42 4/20/2024
0.13.1-dev.55 42 4/20/2024
0.13.1-dev.54 38 4/20/2024
0.13.1-dev.53 43 4/20/2024
0.13.1-dev.52 32 4/19/2024
0.13.1-dev.51 31 4/19/2024
0.13.1-dev.50 35 4/18/2024
0.13.1-dev.49 51 4/15/2024
0.13.1-dev.48 40 4/15/2024
0.13.1-dev.47 45 4/14/2024
0.13.1-dev.45 39 4/13/2024
0.13.1-dev.44 45 4/13/2024
0.13.1-dev.43 43 4/13/2024
0.13.1-dev.41 43 4/13/2024
0.13.1-dev.40 42 4/12/2024
0.13.1-dev.39 38 4/11/2024
0.13.1-dev.38 40 4/10/2024
0.13.1-dev.37 44 4/9/2024
0.13.1-dev.36 44 4/8/2024
0.13.1-dev.35 41 4/7/2024
0.13.1-dev.34 39 4/7/2024
0.13.1-dev.33 46 4/7/2024
0.13.1-dev.32 45 4/6/2024
0.13.1-dev.31 44 4/5/2024
0.13.1-dev.29 38 4/5/2024
0.13.1-dev.28 36 4/5/2024
0.13.1-dev.27 41 4/4/2024
0.13.1-dev.26 46 4/3/2024
0.13.1-dev.25 52 4/3/2024
0.13.1-dev.24 41 4/3/2024
0.13.1-dev.22 41 4/3/2024
0.13.1-dev.21 39 4/3/2024
0.13.1-dev.20 41 4/3/2024
0.13.1-dev.19 44 4/3/2024
0.13.1-dev.18 36 4/3/2024
0.13.1-dev.17 41 4/2/2024
0.13.1-dev.16 47 4/1/2024
0.13.1-dev.15 49 4/1/2024
0.13.1-dev.13 42 3/30/2024
0.13.1-dev.12 44 3/27/2024
0.13.1-dev.11 50 3/24/2024
0.13.1-dev.10 45 3/23/2024
0.13.1-dev.9 48 3/22/2024
0.13.1-dev.7 44 3/18/2024
0.13.1-dev.5 42 3/9/2024
0.13.1-dev.3 43 3/7/2024
0.13.1-dev.2 43 3/7/2024
0.13.1-dev.1 48 3/6/2024
0.13.0 138 3/6/2024
0.12.3-dev.157 42 3/6/2024
0.12.3-dev.156 48 3/6/2024
0.12.3-dev.155 51 3/6/2024
0.12.3-dev.151 29 3/5/2024
0.12.3-dev.150 45 3/4/2024
0.12.3-dev.149 44 3/4/2024
0.12.3-dev.148 44 3/4/2024
0.12.3-dev.147 43 3/3/2024
0.12.3-dev.145 45 3/3/2024
0.12.3-dev.144 41 3/3/2024
0.12.3-dev.143 46 3/3/2024
0.12.3-dev.142 50 3/2/2024
0.12.3-dev.141 43 3/2/2024
0.12.3-dev.140 39 2/29/2024
0.12.3-dev.139 44 2/29/2024
0.12.3-dev.137 48 2/28/2024
0.12.3-dev.134 34 2/28/2024
0.12.3-dev.133 42 2/28/2024
0.12.3-dev.132 44 2/27/2024
0.12.3-dev.131 42 2/26/2024
0.12.3-dev.130 41 2/26/2024
0.12.3-dev.128 40 2/25/2024
0.12.3-dev.127 39 2/25/2024
0.12.3-dev.120 51 2/24/2024
0.12.3-dev.119 47 2/24/2024
0.12.3-dev.118 39 2/23/2024
0.12.3-dev.116 39 2/23/2024
0.12.3-dev.115 47 2/23/2024
0.12.3-dev.114 53 2/19/2024
0.12.3-dev.113 58 2/12/2024
0.12.3-dev.110 52 2/8/2024
0.12.3-dev.108 46 2/7/2024
0.12.3-dev.107 48 2/6/2024
0.12.3-dev.106 51 2/4/2024
0.12.3-dev.103 54 2/1/2024
0.12.3-dev.102 50 1/31/2024
0.12.3-dev.100 46 1/31/2024
0.12.3-dev.99 51 1/28/2024
0.12.3-dev.98 43 1/27/2024
0.12.3-dev.97 49 1/27/2024
0.12.3-dev.95 47 1/26/2024
0.12.3-dev.94 50 1/24/2024
0.12.3-dev.93 47 1/22/2024
0.12.3-dev.92 50 1/21/2024
0.12.3-dev.91 47 1/21/2024
0.12.3-dev.88 48 1/18/2024
0.12.3-dev.87 49 1/18/2024
0.12.3-dev.85 58 1/14/2024
0.12.3-dev.84 49 1/14/2024
0.12.3-dev.83 55 1/10/2024
0.12.3-dev.82 62 1/9/2024
0.12.3-dev.81 53 1/7/2024
0.12.3-dev.80 53 1/6/2024
0.12.3-dev.79 50 1/6/2024
0.12.3-dev.78 54 1/6/2024
0.12.3-dev.77 49 1/6/2024
0.12.3-dev.76 64 1/6/2024
0.12.3-dev.75 56 1/6/2024
0.12.3-dev.74 52 1/6/2024
0.12.3-dev.72 57 1/5/2024
0.12.3-dev.71 52 1/4/2024
0.12.3-dev.69 62 1/1/2024
0.12.3-dev.68 68 12/29/2023
0.12.3-dev.65 70 12/20/2023
0.12.3-dev.64 78 12/8/2023
0.12.3-dev.63 63 12/6/2023
0.12.3-dev.62 56 12/5/2023
0.12.3-dev.61 65 12/5/2023
0.12.3-dev.60 70 12/5/2023
0.12.3-dev.41 55 12/4/2023
0.12.3-dev.40 63 12/1/2023
0.12.3-dev.39 49 11/29/2023