LinuxCommandLibrary

cradle-sql

Run SQL queries against Cradle databases

TLDR

Rebuild the database schema

$ cradle sql build
copy

Rebuild the database schema for a specific package
$ cradle sql build [package]
copy

Empty the entire database
$ cradle sql flush
copy

Empty the database tables for a specific package
$ cradle sql flush [package]
copy

Populate the tables for all packages
$ cradle sql populate
copy

Populate the tables for a specific package
$ cradle sql populate [package]
copy

SYNOPSIS

cradle-sql [options] [database] [sql-query]

PARAMETERS

-h, --help
    Display help and exit

-v, --version
    Show version information

-d, --database DB_PATH
    Specify Cradle database path

-q, --query SQL
    Execute SQL query directly

-f, --file FILE
    Run SQL from file

--user USERNAME
    Database username

--password PASSWORD
    Database password (insecure)

DESCRIPTION

The cradle-sql command is not a standard Linux utility found in common distributions like Ubuntu, Fedora, or Debian. It does not appear in core man pages or typical package repositories (e.g., apt, yum). It may refer to a specialized tool from a niche software suite, such as a database interface for 'Cradle' systems (e.g., PTC Integrity Lifecycle Manager's Cradle, a requirements management tool with SQL backends) or a custom script in proprietary environments.

If installed via a specific package (e.g., from source or vendor repo), it likely provides an SQL query interface to Cradle databases, allowing execution of SQL statements against embedded or linked databases. Without official documentation, usage is unclear; check local man pages (man cradle-sql) or package info. For standard SQL tools, consider sqlite3 or psql.

Attempting to run it on standard systems yields 'command not found'. Verify installation context before use.

CAVEATS

Not standard; may require proprietary Cradle software installation.
Potential security risks with plain-text passwords.
Limited portability across Linux distros.

INSTALLATION

Typically bundled with PTC Cradle; download from vendor site, not standard repos. Source builds rare.

ALTERNATIVES

Use sqlite3 for local SQL or ODBC/JDBC bridges for Cradle integration.

HISTORY

Likely developed as part of PTC's Cradle toolset (1990s origins, evolved for engineering data management). No public changelog; tied to commercial releases.

SEE ALSO

sqlite3(1), psql(1), mysql(1), sqlcmd(1)

Copied to clipboard