cradle-sql
Run SQL queries against Cradle databases
TLDR
Rebuild the database schema
Rebuild the database schema for a specific package
Empty the entire database
Empty the database tables for a specific package
Populate the tables for all packages
Populate the tables for a specific package
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.


