Skip to content

Instantly share code, notes, and snippets.

View phartenfeller's full-sized avatar

Philipp Hartenfeller phartenfeller

View GitHub Profile
@phartenfeller
phartenfeller / data_parser.sql
Created December 13, 2024 16:50
Demo on how to use the data parser package on excel sheets
-- list files:
select * from apex_application_temp_files
-- read sheets:
select * from table(
apex_data_parser.get_xlsx_worksheets(
p_content => (select BLOB_CONTENT from apex_application_temp_files where id = :P5_SELECTED_FILE )
)
)
where :P5_SELECTED_FILE is not null
#!/usr/bin/env bun
import { spawn } from "bun";
class SQLclMCPExplorer {
private sqlPath: string;
private process?: any;
private initialized = false;
constructor(sqlPath: string) {