DuckDB Overview Dashboard
This dashboard provides an overview of your DuckDB database, including a list of all tables. Use this to quickly understand the structure and contents of your DuckDB instance.
List of Tables
SELECT table_name FROM information_schema.tables WHERE table_schema = 'main' ORDER BY table_name; Row Count for service_log
SELECT COUNT(*) AS row_count FROM service_log; Database Files (if using ATTACH)
PRAGMA database_list; All Available Tables (for reference)
SELECT table_schema, table_name FROM information_schema.tables ORDER BY table_schema, table_name; Schema for service_log
PRAGMA table_info('service_log'); Recent Service Log Entries
SELECT
service_name,
status,
timestamp,
message
FROM service_log
ORDER BY timestamp DESC
LIMIT 100;