Production-ready Counter-Strike 2 stats plugin for CounterStrikeSharp. Captures every game event in real time, persists it to MySQL, and aggregates it at three granularity levels: lifetime, session, and per map.

→ Live demo dashboard — a showcase site with example charts and a full catalogue of every stat the plugin can capture or derive.

• Live Demo
• Features
• How It Works
• Requirements
• Installation
• Configuration
• In-Game Commands
• Database Schema
• Updating
• Multi-Server Setup
• Webhook Milestones
• Local Development
• Contributing

neutronbzh.github.io/cs2-statplay-site — a static showcase site (source) with a full catalogue of every stat the plugin captures directly vs. every stat that can be derived from it (K/D, ADR, headshot %, multi-kills, entry kills, win rate, server presence…), plus an example dashboard built with fictional data to show what it renders like.

v1.1.0 additions

• !stats, !rank, !top in-game chat commands
• Player display name stored and updated on each connect
• winner_team on every round
• Hostage events table (hostage_rescued, hostage_killed)
• Versioned schema migrations — zero manual ALTER TABLE on upgrades
• Multi-server support — each server tracked independently
• Milestone webhook — HTTP POST when a player crosses a kill threshold

flowchart LR
    A[CS2 Game Events] --> B[StatsCaptureService\nin-memory buffer]
    B -->|flush every 15 s| C[MySqlStatsWriter\ntransactional batch]
    C --> D[(MySQL\nraw event tables)]
    D -->|stored procedures| E[(MySQL\naggregate tables)]
    E --> F[Website / API / Dashboard / AI]

Key components

• Counter-Strike 2 dedicated server (Linux x64)
• MetaMod:Source installed
• CounterStrikeSharp installed
• MySQL 8+ (or MariaDB 10.5+)

CREATE DATABASE cs2_stats CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'cs2stats'@'%' IDENTIFIED BY 'your-secure-password';
GRANT ALL PRIVILEGES ON cs2_stats.* TO 'cs2stats'@'%';
FLUSH PRIVILEGES;

The plugin auto-creates all tables and applies migrations on first start. No manual SQL import needed.

Go to Releases and download:

• CS2-STATPLAY-x.x.x-linux-x64.zip — full install (includes default config)
• CS2-STATPLAY-x.x.x-linux-x64-update-no-config.zip — update only (preserves your existing config)

# From your game/csgo/ directory
unzip CS2-STATPLAY-x.x.x-linux-x64.zip

Final paths after extraction:

game/csgo/addons/counterstrikesharp/plugins/CS2Stats/CS2Stats.dll
game/csgo/addons/counterstrikesharp/configs/plugins/CS2Stats/CS2Stats.json

Edit game/csgo/addons/counterstrikesharp/configs/plugins/CS2Stats/CS2Stats.json with your MySQL credentials (see Configuration).

On startup the plugin will:

1. Connect to MySQL
2. Create the database if it does not exist
3. Create all tables
4. Apply any pending schema migrations
5. Start capturing events

Verify the plugin loaded with css_plugins list in the server console.

Full reference for CS2Stats.json:

{
  "server": {
    "name": "my-server-1"
  },
  "mySql": {
    "host": "127.0.0.1",
    "port": 3306,
    "database": "cs2_stats",
    "username": "cs2stats",
    "password": "your-password",
    "sslRequired": false
  },
  "modules": {
    "sessionTrackingEnabled": true,
    "kdaEnabled": true,
    "weaponFireEnabled": true,
    "grenadeStatsEnabled": true,
    "objectiveStatsEnabled": true,
    "presenceSnapshotsEnabled": true
  },
  "sync": {
    "flushIntervalSeconds": 15,
    "presenceSnapshotIntervalSeconds": 10,
    "maxBufferedEvents": 5000
  },
  "webhook": {
    "url": "",
    "killsMilestone": 100
  }
}

server

mySql

modules — set any field to false to stop collecting that category of data

sync

webhook

Players type these in chat (the ! prefix is handled automatically by CounterStrikeSharp).

The plugin manages two layers of tables automatically.

Written directly by the plugin on each flush.

Refreshed automatically by stored procedures after each flush.

You can also call the stored procedures directly:

-- Refresh all players
CALL sp_refresh_player_lifetime_stats(NULL);

-- Refresh a specific player (player_id = 42)
CALL sp_refresh_player_lifetime_stats(42);

-- Refresh a specific session
CALL sp_refresh_player_session_stats(7);

-- Refresh a specific player on a specific map session
CALL sp_refresh_player_map_stats(42, 3);

For a complete field-by-field reference with example queries, see docs/STATS_DATA_REFERENCE.md.

Always use the -update-no-config package when upgrading an existing installation. It replaces the plugin binary without touching your CS2Stats.json.

unzip CS2-STATPLAY-x.x.x-linux-x64-update-no-config.zip

Schema migrations are applied automatically on the next server start — no manual SQL needed.

Point multiple game servers at the same MySQL database and set a unique server.name in each config:

// Server 1 — competitive
{ "server": { "name": "eu-competitive-1" } }

// Server 2 — deathmatch
{ "server": { "name": "eu-deathmatch-1" } }

Each server gets its own row in the servers table. All map_sessions carry a server_id foreign key, so you can filter or aggregate stats per server in SQL.

When webhook.url is set, the plugin sends an HTTP POST every time a player's kill count (tracked since server start) crosses a multiple of webhook.killsMilestone.

Example payload

{
  "event": "milestone",
  "server": "my-server-1",
  "steamId64": "76561198000000001",
  "playerName": "PlayerName",
  "milestone": "kills",
  "value": 100,
  "timestamp": "2025-06-09T14:32:00Z"
}

The request is fire-and-forget and never blocks the game thread. Network errors are logged as warnings and do not affect plugin operation. Leave url empty to disable this feature entirely.

dotnet restore CSStat.sln
dotnet build CSStat.sln
dotnet test CSStat.sln

./scripts/package-release.ps1 `
  -Configuration Release `
  -Version 1.1.0 `
  -PackageId CS2-STATPLAY `
  -RuntimeIdentifier linux-x64

Output:

artifacts/
  CS2-STATPLAY-1.1.0-linux-x64.zip
  CS2-STATPLAY-1.1.0-linux-x64-update-no-config.zip
  SHA256SUMS.txt

CSStat.sln
├── src/
│   ├── CS2Stats.Contracts/       # Shared event records and config types
│   ├── CS2Stats.Plugin/          # Plugin, writer, capture, commands, webhook
│   └── CS2Stats.Tests/           # Unit tests (xUnit)
├── sql/                          # Baseline schema and stored procedures
├── config/                       # Example config file
├── scripts/                      # Release packaging script
└── docs/                         # Data reference and architecture notes

See CONTRIBUTING.md for guidelines.
Security issues: see SECURITY.md.
License: MIT.