Adminer

Adminer and Adminer Editor can be extended by plugins. To use a plugin

adminer.js (Roy Orbitson): adminer.js を読込み
backward-keys: Adminer Editor と同様に、カレント行を参照しているテーブルへのリンクを表示 (screenshot)
before-unload: フォームの列が変更された時、ページを再読込みする前に確認を表示
config: ユーザオプションを設定し cookie に保存 (screenshot)
dark-switcher: ダークモードへの切替え (screenshot)
database-hide: 一部データベースを UI 上で表示禁止 (デザイン的な効果のみでセキュリティ的には効果なし)
designs: テーマ設定を有効化 (screenshot)
dump-alter: データベース (開発用など) をエクスポートし、別のデータベース (本番用など) と同期 (screencast)
dump-bz2: Bzip2 形式でエクスポート
dump-date: エクスポートファイル名に現在日時を含める
dump-json: JSON 形式でエクスポート
dump-php (Martin Zeman): PHP 形式でエクスポート
dump-xml: 構造化 XML 形式でエクスポート value
dump-zip: ZIP 形式でエクスポート

edit-calendar: 各日時列に jQuery UI の Timepicker を表示

edit-foreign: 外部キーを編集フォームで選択

edit-textarea: char や varchar にを使用</li> <li><a href="/download/v5.3.0/plugins/editor-setup.php">editor-setup</a>: Adminer Editor で使用するドライバ、サーバ、データベースを設定</li> <li><a href="/download/v5.3.0/plugins/editor-views.php">editor-views</a>: Adminer Editor にビューを表示</li> <li><a href="/download/v5.3.0/plugins/email-table.php">email-table</a>: メールの件名と本文をデータベースから取得 (Adminer Editor)</li> <li><a href="/download/v5.3.0/plugins/enum-option.php">enum-option</a>: 列挙型の編集に <input type="radio"> ではなく <select><option> を使用</li> <li><a href="/download/v5.3.0/plugins/file-upload.php">file-upload</a>: 列名が "_path" で終わる列を <input type="file"> で変更し、"選択" からアップロードされたファイルにリンク</li> <li><a href="/download/v5.3.0/plugins/foreign-system.php">foreign-system</a>: システムテーブル ("mysql" と "information_schema") を外部キーを用いて接続</li> <li><a href="/download/v5.3.0/plugins/frames.php">frames</a>: フレーム内での Adminer 利用を許可</li> <li><a href="/download/v5.3.0/plugins/codemirror.php">highlight-codemirror</a>: CodeMirror 5 を用い、キーワードやテーブルを含む構文や <textarea> を強調表示 (<a rel="screenshot" href="/static/plugins/codemirror.gif" title="codemirror">screenshot</a>)</li> <li><a href="/download/v5.3.0/plugins/monaco.php">highlight-monaco</a>: 構文や <textarea> の強調表示に VS Code の Monaco Editor を使用</li> <li><a href="/download/v5.3.0/plugins/prism.php">highlight-prism</a>: 構文や <textarea> の強調表示に Prism Code Editor を使用</li> <li><a href="/download/v5.3.0/plugins/json-column.php">json-column</a>: JSON 値をテーブルとして編集画面に表示</li> <li><a href="/download/v5.3.0/plugins/login-ip.php">login-ip</a>: IP アドレスの確認、及び空パスワードの許可</li> <li><a href="/download/v5.3.0/plugins/login-otp.php">login-otp</a>: ログイン時にワンタイムパスワード (二要素認証) が必要 (<a href="/ja/plugins/otp/">instructions</a>)</li> <li><a href="/download/v5.3.0/plugins/login-password-less.php">login-password-less</a>: パスワードなしのログインを許可 (<a href="/download/v5.3.0/adminer/sqlite.php">example</a>)</li> <li><a href="/download/v5.3.0/plugins/login-servers.php">login-servers</a>: ログイン画面に定義済のサーバリストを表示</li> <li><a href="/download/v5.3.0/plugins/login-ssl.php">login-ssl</a>: MySQL, PostgreSQL, MS SQL への接続時に SSL を利用</li> <li><a href="/download/v5.3.0/plugins/login-table.php">login-table</a>: "login" テーブルによるユーザ認証</li> <li><a href="/download/v5.3.0/plugins/master-slave.php">master-slave</a>: マスタ書込みとスレーブ読込みの有効化</li> <li><a href="/download/v5.3.0/plugins/menu-links.php">menu-links</a>: メニュー内テーブルへのリンク設定; AdminerConfig との併用可 (<a rel="screenshot" href="/static/plugins/menu-links.png" title="menu-links">screenshot</a>)</li> <li><a href="/download/v5.3.0/plugins/pretty-json-column.php">pretty-json-column</a> (Christopher Chen): 編集時に JSON 文字列を見易く表示</li> <li><a href="/download/master/plugins/row-numbers.php">row-numbers</a>: Display row numbers in select</li> <li><a href="/download/v5.3.0/plugins/select-email.php">select-email</a>: テーブルに含まれるメールアドレスにメールを送信</li> <li><a href="/download/v5.3.0/plugins/slugify.php">slugify</a>: 列名に "_slug" を含む列を、前列の URL 化された値でプレフィル (JavaScript)</li> <li><a href="/download/v5.3.0/plugins/sql-gemini.php">sql-gemini</a>: Google Gemini AI を用いて SQL 文を生成 (<a rel="screenshot" href="/static/plugins/sql-gemini.gif" title="sql-gemini">screenshot</a>, <a rel="screenshot" href="/static/plugins/sql-gemini2.gif" title="sql-gemini">2</a>, <a rel="screenshot" href="/static/plugins/sql-gemini3.gif" title="sql-gemini">3</a>, <a rel="screenshot" href="/static/plugins/sql-gemini4.gif" title="sql-gemini">4</a>)</li> <li><a href="/download/v5.3.0/plugins/sql-log.php">sql-log</a>: 全クエリを SQL ファイルに記録</li> <li><a href="/download/v5.3.0/plugins/table-indexes-structure.php">table-indexes-structure</a> (Matthew Gamble): テーブルのインデックス構造を拡張表示</li> <li><a href="/download/v5.3.0/plugins/table-structure.php">table-structure</a> (Matthew Gamble): テーブル構造を拡張表示</li> <li><a href="/download/v5.3.0/plugins/tables-filter.php">tables-filter</a>: テーブル一覧をテーブル名でフィルタリング</li> <li><a href="/download/v5.3.0/plugins/tinymce.php">tinymce</a>: 列名が "_html" を含む列を TinyMCE の HTML エディタで編集し、編集結果の HTML コードを "選択" 画面に表示</li> <li><a href="/download/v5.3.0/plugins/translation.php">translation</a>: テーブル "translation" を用いてすべてのテーブルや列のコメント、列挙型、セット値を翻訳 (自動的に翻訳文で更新)</li> <li><a href="/download/v5.3.0/plugins/version-github.php">version-github</a>: GitHub の新版を管理</li> <li><a href="/download/v5.3.0/plugins/version-noverify.php">version-noverify</a>: バージョンチェックを無効化</li> </ul> <h3 id="driver">Driver plugins</h3> <ul> <li><a href="/download/v5.3.0/plugins/drivers/elastic.php">elastic</a>: Driver for <a href="https://www.elastic.co/elasticsearch" target="_blank">Elasticsearch</a></li> <li><a href="/download/v5.3.0/plugins/drivers/mongo.php">mongo</a>: Driver for <a href="https://www.mongodb.com/" target="_blank">MongoDB</a></li> <li><a href="/download/v5.3.0/plugins/drivers/firebird.php">firebird</a>: Driver for <a href="https://www.firebirdsql.org/" target="_blank">Firebird</a></li> <li><a href="/download/v5.3.0/plugins/drivers/clickhouse.php">clickhouse</a>: Driver for <a href="https://clickhouse.com/" target="_blank">ClickHouse</a></li> <li><a href="/download/v5.3.0/plugins/drivers/simpledb.php">simpledb</a>: Driver for <a href="https://aws.amazon.com/simpledb/" target="_blank">SimpleDB</a></li> <li><a href="/download/v5.3.0/plugins/drivers/imap.php">imap</a>: Driver for IMAP (<a href="/static/plugins/imap.png" rel="screenshot" title="IMAP">screenshot</a>)</li> </ul> <h3 id="use">To use a plugin</h3> <img src="/static/plugins-dir-structure.png" width="210" height="120" alt="" align="right">To use a plugin, upload it to <code>adminer-plugins/</code> directory next to <code>adminer.php</code> file. If the plugin needs some configuration or you want to specify order of the plugins, use <code>adminer-plugins.php</code>: <pre><code class="jush"><?php // adminer-plugins.php return array( new AdminerLoginPasswordLess('$2y$07$Czp9G/aLi3AnaUqpvkF05OHO1LMizrAgMLvnaOdvQovHaRv28XDhG'), // You can specify all plugins here or just the ones needing configuration. ); </code></pre> You can upload <a href="#driver">driver plugins</a> to <code>adminer-plugins/</code> too. <h3 id="user" target="_blank">User contributed plugins</h3> <a href="?newest=1#user">Newest first</a> <ul>  <li> <a href="https://github.com/LinkedList/Adminer-Allowed-Prefixes" target="_blank">allowed-prefixes</a> (Martin Macko): Show only tables with user set prefixes (2025-03-18) </li> <li> <a href="https://github.com/natanfelles/adminer-bootstrap-like" target="_blank">bootstrap-like-design</a> (Natan Felles): User interface inspired by the Bootstrap Framework with Font-Awesome icons. (2025-03-26) </li> <li> <a href="https://github.com/margenn/adminer-camera-upload-plugin" target="_blank">camera-upload</a> (Marcelo Gennari): Upload images from Adminer to server's disc (needs WebcamJS library) (2025-03-17) </li> <li> <a href="https://github.com/vrana/adminer-plugins-pematon/blob/master/AdminerCollations.php" target="_blank">collations</a> (Pematon): Custom character sets in collation select boxes (2025-03-16) </li> <li> <a href="https://github.com/smuuf/adminer-colorfields" target="_blank">colorfields</a> (Prema van Smuuf): Display colors if color codes (HEX, RGB) are present in cells (2016-04-21) </li> <li> <a href="https://github.com/fprochazka/adminer-colors" target="_blank">colors</a> (Filip Procházka): Color ribbon based on server (2016-04-12) </li> <li> <a href="https://github.com/tomgoodsun/adminer-show-column-comment" target="_blank">column-comment</a> (Tomohito Higuchi): Show column comments in table headers (2025-03-16) </li> <li> <a href="https://github.com/icyz/adminer/blob/master/plugins/add-button-column-header.php" target="_blank">column-header-button</a> (Andrea Mariani): Add "Distinct" on each column (2025-04-12, <a rel="screenshot" href="/static/plugins/column-header-button.png" title="column-header-button">screenshot</a>) </li> <li> <a href="https://gist.github.com/821510" target="_blank">convention-foreign-keys</a> (Ivan Nečas): Links for foreign keys by convention <code>user_id</code> => <code>users.id</code> (2011-02-10) </li> <li> <a href="https://github.com/adilyildiz/AdminerCopy" target="_blank">copy</a> (Adil Yildiz): Copy cell content to clipboard using right click (2020-02-17) </li> <li> <a href="https://github.com/mmokross/AdminerCustomizeThemeBasedOnServer" target="_blank">customize-theme-based-on-server</a> (Michael Mokroß): Add a server-specific CSS file to the current theme (2025-03-16) </li> <li> <a href="https://github.com/ToX82/adminer-db-structure-plugin" target="_blank">db-structure</a> (Emanuele Toscano): Generates an AI-friendly markdown schema for your database or selected tables (2025-03-11) </li> <li> <a href="https://github.com/icyz/adminer/blob/master/plugins/disable-tables.php" target="_blank">disable-tables</a> (Andrea Mariani): Disable tables based on the name (2025-04-12) </li> <li> <a href="https://gist.github.com/scr4bble/b472f3683b7e03200df60c7366f08b97" target="_blank">display-foreign-key-name</a> (Bruno Vibert): Display the first CHAR/VARCHAR column of a foreign key (2025-03-19) </li> <li> <a href="https://github.com/fthiella/adminer-plugin-dump-markdown" target="_blank">dump-markdown</a> (Federico Thiella): Export table data as markdown (2025-03-27) </li> <li> <a href="https://github.com/sc419/AdminerDumpMarkdownDict" target="_blank">dump-markdown-dict</a> (sc419): Export table structure as markdown (2019-02-15) </li> <li> <a href="https://github.com/dg/adminer" target="_blank">dump-nette</a> (David Grudl): Export as PHP code for Nette (2025-06-10) </li> <li> <a href="https://github.com/Gobie/adminer-plugins" target="_blank">dump-xml-dataset</a> (Michal Brašna): Dump to XML format specifically PHPUnit's XML DataSet structure (2025-03-16) </li> <li> <a href="https://github.com/LinkedList/FasterTablesFilter" target="_blank">faster-tables-filter</a> (Martin Macko): Filter tables menu faster than the official plugin (2025-03-18) </li> <li> <a href="https://github.com/icyz/adminer/blob/master/plugins/favorite-query.php" target="_blank">favorite-query</a> (Andrea Mariani): Save queries as favorites (2025-04-12, <a rel="screenshot" href="/static/plugins/favorite-query.png" title="favorite-query">screenshot</a>) </li> <li> <a href="https://openuserjs.org/scripts/knedle/Adminer_-_favorites_tables" target="_blank">favorites tables</a> (Ladislav Ševcůj): Pin favorite tables in table menu (needs jQuery library) (2016-12-16) </li> <li> <a href="https://github.com/arxeiss/Adminer-FillLoginForm" target="_blank">fill-login-form</a> (Pavel Kutáč): Fill login form by set values (2025-03-11) </li> <li> <a href="https://github.com/icyz/adminer/blob/master/plugins/fk-disable.php" target="_blank">fk-disable</a> (Andrea Mariani): Disable foreign key checks for selected queries (2025-04-12) </li> <li> <a href="https://github.com/stano/adminer-floatThead" target="_blank">float-thead</a> (Stano Paška): Floating table headers (needs jQuery and floatThead) (2025-03-16) </li> <li> <a href="https://gist.github.com/Roy-Orbison/52f20d5b2eacd9ad3b828ca225202982" target="_blank">folder-import</a> (Roy-Orbison): Import SQL files from server's disc (2025-03-16) </li> <li> <a href="https://github.com/mhucik/AdminerForeignKeysPlugin" target="_blank">foreign-keys</a> (Marek Hučík): Show links to related tables by foreign key (2025-04-01) </li> <li> <a href="https://github.com/arxeiss/Adminer-HideTables" target="_blank">hide-tables</a> (Pavel Kutáč): Hide tables from table menu (2025-03-11) </li> <li> <a href="https://github.com/derStephan/AdminerPlugins/blob/master/hideableColumns.php" target="_blank">hideable-columns</a> (Stephan): Hide columns from tables by Alt+click on column header (2023-03-21) </li> <li> <a href="https://github.com/dg/adminer" target="_blank">highlight-ace</a> (David Grudl): Autocomplete SQL for keywords, tables and columns using Ace Editor (2025-06-10) </li> <li> <a href="https://github.com/vlgalik/adminer-imagefields" target="_blank">imagefields</a> (Ladislav Gálik): Load images from their URL and show them in the tables (2025-06-12) </li> <li> <a href="https://github.com/arxeiss/adminer-input-uuid-generator" target="_blank">input-uuid-generator</a> (Pavel Kutáč): Adds buttons to cells to create UUIDs (2025-03-11) </li> <li> <a href="https://github.com/natanfelles/adminer-ispconfig" target="_blank">ispconfig</a> (Natan Felles): Authenticate and auto-check host by ISPConfig Remote API (2025-03-26) </li> <li> <a href="https://github.com/vrana/adminer-plugins-pematon/blob/master/AdminerJsonPreview.php" target="_blank">json-preview</a> (Pematon): Display JSON values as table (2025-03-16) </li> <li> <a href="https://gist.github.com/marcbln/22dd713966cbda67af2e6bfc465a5c46" target="_blank">json-var-dumper</a> (Marc Christenfeldt): Export table data to JSON (needs symfony/var-dumper) (2020-05-18) </li> <li> <a href="https://github.com/Roy-Orbison/adminer-login-external" target="_blank">login-external</a> (Roy Orbison): Login from external source without exposing credentials (2025-03-17) </li> <li> <a href="https://github.com/vrana/adminer-plugins-pematon/blob/master/AdminerLoginServers.php" target="_blank">login-servers</a> (Pematon): Display list of predefined servers with different drivers in login form (2025-03-16) </li> <li> <a href="https://github.com/crazy-max/login-servers-enhanced" target="_blank">login-servers-enhanced</a> (CrazyMax): Display a list of predefined database servers in login form (2025-04-13) </li> <li> <a href="https://github.com/rohusan/adminer-plugin-sqlite" target="_blank">login-sqlite</a> (rohusan): SQLite: Show only list of DBs and password in login form (2025-04-22) </li> <li> <a href="https://github.com/dg/adminer" target="_blank">login-without-credentials</a> (David Grudl): Allows login without password from localhost (2025-06-10) </li> <li> <a href="https://gist.github.com/3423745" target="_blank">nette-user-login</a> (Mikuláš Dítě): Nette framework user login (2012-08-22) </li> <li> <a href="https://github.com/giofreitas/one-click-login" target="_blank">one-click-login</a> (Sérgio Freitas): Display a list of predefined database servers to login with just one click (2018-07-18) </li> <li> <a href="https://github.com/gremki/AdminerPHPExport" target="_blank">php-export</a> (Adrian Andreescu): Export table data to PHP arrays (2025-06-29) </li> <li> <a href="https://gist.github.com/donwilson/0bc0ec7c3701fb20747777a1a7b4cab4" target="_blank">php-serialized-data</a> (Don Wilson): Display serialized PHP values as table in edit (2025-03-17) </li> <li> <a href="https://gist.github.com/scr4bble/9ee4a9f1405ffc1465f59e03768e2768" target="_blank">readable-dates</a> (Dora Bulkins): Replaces UNIX timestamps with human-readable dates in your local format (2018-02-06) </li> <li> <a href="https://github.com/TiagoGilMarques/adminer.resize" target="_blank">resize</a> (Tiago Gil Marques): Resize table menu (needs jQuery and jQuery cookie libraries) (2020-11-11) </li> <li> <a href="https://gist.github.com/NoxArt/8085521" target="_blank">restore-menu-scroll</a> (Jiří Petruželka): Remembers and restores scollbar position of side menu (2025-03-18) </li> <li> <a href="https://github.com/dg/adminer" target="_blank">save-menu-pos</a> (David Grudl): Save position of the menu in designs with separate menu scrolling (2025-06-10) </li> <li> <a href="https://github.com/MartinZubek/adminer-schema-default-to-public" target="_blank">schema-default-to-public</a> (Martin Zubek): Objects not found in current scheme are also searched for in the public scheme (PostgreSQL only) (2025-03-16) </li> <li> <a href="https://github.com/derStephan/AdminerPlugins/blob/master/searchAutocomplete.php" target="_blank">search-autocomplete</a> (Stephan): Excel-like behaviour with auto-complete in the search-fields (2022-08-30) </li> <li> <a href="https://github.com/andit-ogihara/adminer-show-table-row" target="_blank">show-table-row</a> (Kazuhiro Ogihara): Show one table row on a single page (2025-03-17) </li> <li> <a href="https://github.com/vrana/adminer-plugins-pematon/blob/master/AdminerSimpleMenu.php" target="_blank">simple-menu</a> (Pematon): Displays only the prefered action in table menu (2025-03-16) </li> <li> <a href="https://gist.github.com/MichalSkoula/b0df289804f0c216200732624468a765" target="_blank">sql-claude</a> (Michal Škoula): AI prompt in SQL command generating the queries with Anthropic Claude (2025-04-25) </li> <li> <a href="https://github.com/dg/adminer" target="_blank">sql-wizard</a> (David Grudl): Generate SQL queries from natural language prompts using ChatGPT (2025-06-10) </li> <li> <a href="https://github.com/derStephan/AdminerPlugins/blob/master/stickyColumns.php" target="_blank">sticky-columns</a> (Stephan): Keep columns and table headers always in sight when scrolling (2022-08-30) </li> <li> <a href="https://github.com/icyz/adminer/blob/master/plugins/suggest-tablefields.php" target="_blank">suggest-tablefields</a> (Andrea Mariani): Suggest fields and table names in sql editor (2025-04-12) </li> <li> <a href="https://github.com/zhgabor/adminer-table-filter" target="_blank">table-filter</a> (Gábor Zabojszky-Horvath): Filter tables menu, works only with custom themes where table list is floated (needs jQuery library) (2020-05-27) </li> <li> <a href="https://github.com/TiagoGilMarques/adminer.tablesCollapse" target="_blank">tables-collapse</a> (Tiago Gil Marques): Collapse tables (needs jQuery and jQuery cookie libraries) (2020-11-13) </li> <li> <a href="https://github.com/brunetton/adminer-tables_fuzzy_search" target="_blank">tables-fuzzy-search</a> (Bruno Duyé): Fuzzy search (filter) in tables list (2017-10-12) </li> <li> <a href="https://gist.github.com/aoloe/303f314aec36851d4c88" target="_blank">tables-history</a> (Ale Rimoldi): Show the history of the last selected tables (2014-06-06) </li> <li> <a href="https://github.com/felladrin/adminer-theme-switcher" target="_blank">theme-switcher</a> (Victor Nogueira): Switch themes from browser or command line (2025-03-17) </li> <li> <a href="https://github.com/PetroKostyuk/adminer-tree-view" target="_blank">tree-view</a> (Petro Kostyuk): Display related rows from different tables in one page (2025-03-16) </li> <li> <a href="https://github.com/tomgoodsun/adminer-dump-xlsx" target="_blank">xlsx-dump</a> (Tomohito Higuchi): Export table data to XLSX (needs SheetJS and FileSaver.js libraries) (2025-07-07) </li> </ul> Adminer 5 plugins require using a namespace. Older plugins can be converted <a href="https://php.vrana.cz/adminer-5-0-0.php#plugins">by a script</a>. <h3 id="create">To create a new plugin</h3> <ol> <li>Create a class containing any methods defined in the <code>Adminer</code> class (<a href="/ja/extension/#api">documentation</a>).</li> <li>If these methods return a non-<code class="jush-php">null</code> value then it will be used instead of the original (except <code>config</code>, <code>dumpFormat</code>, <code>dumpOutput</code>, <code>editRowPrint</code>, <code>editFunctions</code> where the return value is appended to the original).</li> <li>Methods can also overwrite their parameters by accepting them by reference: <code class="jush-php">f(&$param)</code>.</li> <li>If you would like to publish the plugin on this page then upload it somewhere (e.g. to <a href="https://gist.github.com/">GitHub Gist</a>) and send the link to: <a href="mailto:jakub@vrana.cz">jakub@vrana.cz</a>.</li> </ol> <script type="text/javascript" src="/static/jush/2.0.0/jush.js"></script> <style> pre a { text-decoration: none; } </style> <script type="text/javascript"> jush.style("\/" + 'static/jush/2.0.0/jush.css'); jush.create_links = false; jush.highlight_tag('code'); </script> <script type="text/javascript"> jQuery(function ($) { $('a[rel]').fancybox(); }); </script> <div id="footer"> <a href="https://www.vrana.cz/">Jakub Vrána</a>  デザイン: <a href="mailto:jan@smitka.org">Jan Smitka</a>, <a href="http://www.famfamfam.com/lab/icons/silk/">Silk Icons</a>, Translation: <a href="https://php.vrana.cz/">Jakub Vrána</a>, <a href="https://www.vas-hosting.com/?ref=3000">ホスティング</a> </div> </div> </body> </html>

Adminer ­

Adminer - プラグイン