CSQLY.CLI 0.15.0

There is a newer version of this package available.
See the version list below for details.

dotnet tool install --global CSQLY.CLI --version 0.15.0

This package contains a .NET tool you can call from the shell/command line.

dotnet new tool-manifest
                    

                            if you are setting up this repo

dotnet tool install --local CSQLY.CLI --version 0.15.0

This package contains a .NET tool you can call from the shell/command line.

#tool dotnet:?package=CSQLY.CLI&version=0.15.0

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

nuke :add-package CSQLY.CLI --version 0.15.0

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

CSQLY Command Line Interface

CSQLY CLI is a command-line tool for executing YAML-based SQL queries against various database systems.

dotnet tool install --global CSQLY.CLI

csqly --file <path-to-yaml-file> --connection <connection-string> --type <database-type>

Abbreviated options:

csqly -f <path-to-yaml-file> -c <connection-string> -t <database-type>

Option	Abbreviation	Description
`--file`	`-f`	Path to the YAML query file
`--connection`	`-c`	Database connection string
`--type`	`-t`	Database type (sqlite, mysql, postgres, sqlserver, oracle)
`--help`	`-h`	Show help information
`--version`	`-v`	Show version information

csqly -f query.yaml -c "Data Source=mydb.sqlite" -t sqlite

csqly -f query.yaml -c "Server=localhost;Database=mydb;User ID=user;Password=password;" -t mysql

select:
  columns:
    - id
    - name
    - email
  from: users
  where:
    active: true
  limit: 10

For full documentation, visit the GitHub repository.

Product	Compatible and additional computed target framework versions.
.NET	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.

Product

.NET

Compatible target framework(s)

Included target framework(s) (in package)

Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.