PRS

A simple command-line tool to query database schema in Microsoft SQL Server

Introduction:

This is a tool to help you quickly search the names of objects (columns, tables, stored procedure) in Microsoft SQL server. This tool has been released as a dotnet global tool. You can install it by the following dotnet command,

dotnet tool install wooly905.prs -g

The followings are the examples to show you how to use this tool.

The following screenshots show you the tables and columns created by Hangfire.

How to use this tool:

Setup connection string (prs wcs)

This is the first thing to do for this tool. Make sure your connection string is good with correct host URL, database name, username, and password.

Show connection string (prs scs)

Dump schema to local machine (prs dds)

This is the command to dump the database schema into your local user folder. This command must be executed for any query command below.

Find table (prs ft) - table name can be partial

Find column (prs fc) - find matched column in all tables

Find column in table(s) (prs ftc)

Display all columns of a table

Find stored procedure

prs fsp [full or partial name of a storec procedure to find]