CPlanner Analytics Platform

Available API Endpoints

Database Management

GET /admin/database/overview GET

GET /admin/database/analytics-summary GET

GET /admin/database/table/{table}/data GET

POST /admin/database/query POST

Tracking & Analytics

POST /api/track-visit POST

GET /api/test-ip GET

GET /api/test-enhanced GET

GET /api/user-websites-stats/{email} GET

Platform Features

Secure Database Access

Read-only queries with SQL injection protection and secure authentication.

Real-time Analytics

Live tracking of visitors, pageviews, and user interactions across websites.

Responsive Design

Modern, mobile-friendly interfaces built with Tailwind CSS and Alpine.js.

API Documentation

Database Management APIs

# Get database overview
curl http://localhost:4000/admin/database/overview

# Get analytics summary  
curl http://localhost:4000/admin/database/analytics-summary

# Get table data with pagination
curl "http://localhost:4000/admin/database/table/visitors/data?page=1&limit=20"

# Execute custom query
curl -X POST http://localhost:4000/admin/database/query \
  -H "Content-Type: application/json" \
  -d '{"query": "SELECT * FROM visitors LIMIT 10"}'

Tracking APIs

# Track a visit
curl -X POST http://localhost:4000/api/track-visit \
  -H "Content-Type: application/json" \
  -d '{
    "domain": "example.com",
    "visitor_id": "visitor123",
    "url": "https://example.com/page",
    "user_agent": "Mozilla/5.0...",
    "country": "United States"
  }'

# Test IP detection
curl http://localhost:4000/api/test-ip

# Get enhanced tracking example
curl http://localhost:4000/api/test-enhanced

CPlanner

Database Admin

Simple Dashboard

API Documentation

Available API Endpoints

Database Management

Tracking & Analytics

Platform Features

Secure Database Access

Real-time Analytics

Responsive Design

API Documentation

Database Management APIs

Tracking APIs