{"repo":"Angelerator/Sazgar","free":true,"listed":false,"github":"https://github.com/Angelerator/Sazgar","clone":"git clone https://github.com/Angelerator/Sazgar.git","description":"DuckDB extension for system monitoring & intelligent SQL routing. 25+ functions for CPU, memory, disk, network, processes. Conditionally Route queries to PostgreSQL, MySQL, Snowflake, BigQuery with automatic dialect translation via SQLGlot. Pure Rust, cross-platform.","language":"HTML","stars":13,"topics":["bigquery","clickhouse","databricks","duckdb","mysql","postgresql","query-routing","rust","snowflake","sql"],"license":"MIT","category":"databases-storage","readme_excerpt":"Sazgar - DuckDB Extension for System Monitoring & Query Routing Sazgar (Persian: سازگار, meaning \"compatible\") is a DuckDB extension that does two things: 1. System Monitoring - Query your CPU, memory, disk, network, and processes using SQL 2. Query Routing - Run SQL queries on remote databases (PostgreSQL, Tavana, etc.) and get results back --- Installation That's it! You're ready to go. --- Part 1: System Monitoring Query your system like a database: Available Functions Function What it does ---------- -------------- sazgar system() Overall system info (CPU, RAM, uptime) sazgar memory() RAM usage details sazgar cpu() CPU info per core sazgar disks() Disk space usage sazgar network() Network interface stats sazgar processes() Running processes sazgar ports() Open network ports sazgar docker() Docker containers sazgar services() System services All memory/disk functions accept a unit parameter: 'bytes' , 'KB' , 'MB' , 'GB' , 'TB' --- Part 2: Query Routing (The Simple Way) What is it? Run SQL on a remote database and get the results in DuckDB. Step 1: Register Your Database Step 2: Run Queries That's it! The results come back to your local DuckDB. Simple Examples Custom Remote Query Sometimes the remote database has different table names. Use the 4th parameter: What are the 4 parameters? # Parameter Required What it means --- ----------- ---------- --------------- 1 query Yes Your SQL query (DuckDB syntax) 2 target Yes Name you gave in sazgar target() 3 condition Yes SQL expre","default_branch":null,"files":null,"tree":[],"storefront":"/r/Angelerator","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Angelerator/Sazgar/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}