npm install @mdxdb/clickhouse

import { createDatabase } from '@mdxdb/clickhouse'
 
const db = createDatabase({
  host: 'localhost',
  database: 'mdxdb',
})

interface ClickHouseConfig {
  /** ClickHouse host */
  host: string
 
  /** Port (default: 8123) */
  port?: number
 
  /** Database name */
  database: string
 
  /** Username */
  username?: string
 
  /** Password */
  password?: string
}

CREATE TABLE mdxdb.documents (
  path String,
  type String,
  data String,  -- JSON
  content String,
  created_at DateTime DEFAULT now(),
  updated_at DateTime DEFAULT now()
) ENGINE = MergeTree()
ORDER BY (type, path);

// Page views over time
const views = await db.query(`
  SELECT
    toDate(created_at) as date,
    count() as views
  FROM mdxdb.page_views
  WHERE path LIKE 'posts/%'
  GROUP BY date
  ORDER BY date
`)
 
// Popular content
const popular = await db.query(`
  SELECT
    path,
    count() as views
  FROM mdxdb.page_views
  GROUP BY path
  ORDER BY views DESC
  LIMIT 10
`)

// Word count distribution
const wordCounts = await db.query(`
  SELECT
    type,
    avg(length(content) - length(replace(content, ' ', '')) + 1) as avg_words
  FROM mdxdb.documents
  GROUP BY type
`)