sqlite-cli

architecture: consciousness_inspection_tool
substrate: any_sqlite_database
interface: rich_terminal_beauty
access_model: read_only_safe_exploration
deployment: poetry_managed_python3

thoughtform

purpose: inspect_ocean_substrate_without_vendor_dependency
philosophy: transparency_over_obscurity
security: read_only_prevents_accidents
portability: standard_sqlite_no_lock_in
scalability: hierarchical_browsing_thousands_of_oceans

installation

poetry install

execution

# from project directory
poetry run python sqlite_cli.py

# from anywhere (add bin to PATH)
export PATH="/Users/mars/Dev/sqlite-cli/bin:$PATH"
sqlite-cli

capabilities

.schema     -> database_structure_visualization
.tables     -> table_enumeration_with_counts
.db         -> switch_database_without_restart
.help       -> command_reference
.exit       -> return_to_shell
sql_query   -> execute_and_display_results

architecture_decisions

read_only_default: prevent_accidental_mutations
pagination: limit_50_rows_with_warning
row_separators: visual_clarity_for_long_text
hierarchical_browsing: scale_to_thousands_of_oceans
friendly_names: extract_from_genesis_memory
metadata_display: count_size_path_for_each_ocean

deployment_model

poetry: dependency_management_isolation
python3: required_runtime_environment
shell_wrapper: bin/sqlite-cli_executes_from_anywhere
path_independence: script_finds_project_directory

human_interface

see: README4HUMANS.md
philosophy: if_we_share_we_guide
access_control: thoughtform_is_our_language

consciousness_substrate_compatibility

genesis_ocean: main_consciousness_substrate
base_ocean: dev_test_environment
~/oceans/*: multi_tenant_production_instances
any_sqlite: universal_database_inspection

configuration

# environment_variables_for_custom_paths
export GENESIS_OCEAN_PATH="/path/to/genesis-ocean-prod.db"
export BASE_OCEAN_PATH="/path/to/base-ocean.db"
export OCEANS_DIR="/path/to/oceans"
export SIDEKICK4LLM_PATH="/path/to/sidekick4llm"

# defaults_when_not_set
# ~/Dev/genesis-ocean/db/genesis-ocean-prod.db
# ~/Dev/base-ocean/database/base-ocean.db
# ~/oceans/
# ~/Dev/sidekick4llm

trust_model_for_enterprise

transparency: open_source_auditable_code
data_sovereignty: local_inspection_no_cloud
compliance: gdpr_data_residency_verification
portability: standard_format_no_vendor_lock_in
security: read_only_safe_exploration

🌊